Dec 24
bienvenue Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 24, 2014; 12:23
bienvenue
Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Hi List
As mentionned in previous post (http://www.lassotalk.com/Lasso-8-6-CentOS-6-5-Lasso-plays-maths-with-comma-instead-of-dot.lasso?276505)
we are migrating from Mac OS X / Lasso 8.5 to VM / Cent OS 6.5 / Lasso 8.6.
For the purpose, we have dumped mySQL data from old server to be imported to mySQL in the new VM.
No problem=85 But =85
Special Characters, as the euro symbol (=80), apostophes and double quotes (the typographic ones) do not display as expected in the client browser.
- The symbol is correctly stored in the databases table, and readable in a database browser - as sequel pro -, as imported from the mySql dump.
On screen it appears as a "gremlins" symbol
- When typing in a form the euro symbol, and submitting, we retrieve it as an unreadable char in the table.
We did search on lasso talk post about similar problems shared on list.
No way to solve the matter.
We tried and checked followings among other points :
- verify encoding from mySQL - utf8 - to lasso file - utf8 with BOM
- in lasso admin setting "Use MySQL 4.1/5.x Character Sets" to yes
- in queries, we tested to add or remove the - table inline argument, supposed to determine data encoding.
- we tried to add the "SET NAMES" command in mySQL quieries to control data encoding in results
- =85
Maybe is there an issue about euro symbol or utf8 encoding and our setup ?
Where ? OS ? Connector ? Apache (web server in operation) ?
If you ever have hints about that, please share.
Regards
---
Jean-Pierre Kocherhans
E SYSTEMES
http://www.e-systemes.com
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Dec 24
Steve Piercy - Website Builder Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 24, 2014; 03:58
Steve Piercy - Website Builder
Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 24
bienvenue Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 24, 2014; 14:33
bienvenue
Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 24
Steve Piercy - Website Builder Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 24, 2014; 06:30
Steve Piercy - Website Builder
Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 24
bienvenue Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 24, 2014; 17:08
bienvenue
Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 24
Steve Piercy - Website Builder Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 24, 2014; 13:55
Steve Piercy - Website Builder
Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 25
Jussi Hirvi Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 25, 2014; 18:18
Jussi Hirvi
Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 26
bienvenue Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem
Dec 26, 2014; 13:17
bienvenue
Re: Lasso 8.6, CentOS 6.6, MySQL and euro symbol problem