hyperch
Posts: 2
|
Posted: 08/16/2012, 3:58 AM |
|
Hi there
I'm trying to make some contacts database and I did set everything i the project to UTF-8. Also the underlaying linux environment is fully tuned to UTF-8 (apache, php, mysql [utf8-general-ci]).
The problem however is, that when I enter data then through the webform the special chars / Umlaute are stored in mysql like this:
äöü --> which should be "äöü"
When I retrieve the data it is again displayed as "äöü" but just in mysql db itself it is stored wrongly. It seems to me that when the data is being stored it's converted to latin and when retrieved it's converted from latin to utf8.
So, how can I ensure that data is really stored as utf8 in the database?
|
|
|
apexsciences
|
Posted: 08/19/2012, 10:07 AM |
|
Le 2012-08-16 06:58, hyperch a écrit :
> Hi there
>
> I'm trying to make some contacts database and I did set everything i the
> project to UTF-8. Also the underlaying linux environment is fully tuned to
> UTF-8 (apache, php, mysql [utf8-general-ci]).
>
> The problem however is, that when I enter data then through the webform the
> special chars / Umlaute are stored in mysql like this:
>
> äöü --> which should be "äöü"
>
> When I retrieve the data it is again displayed as "äöü" but just in mysql db
> itself it is stored wrongly. It seems to me that when the data is being stored
> it's converted to latin and when retrieved it's converted from latin to utf8.
>
> So, how can I ensure that data is really stored as utf8 in the database?
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
ensure you MySQL database collection supports UTF-8.
I personnally uses collection utf8_general_ci on all my MySQL tables.
Regards, lp
|
|
|
bannedone
Posts: 273
|
Posted: 08/20/2012, 8:03 AM |
|
BTW using any collation in MySql that ends in _ci means the case is insensitive.
When doing this you limit user IDs and passwoirds from using both upper and lower case.
_________________
John Real
CodeCharge Studio Support, Training, Consulting, Development, Web based solutions
http://realsites.biz
http://ccselite.com
Other Banned IDs on this Forum. jjrjr1, jjrjr2 |
|
|
|