Comment 5 for bug 34181
Revision history for this message
| Olivier Cortès (olive) wrote Re: locale and charset problem in mysql | #5 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
513534c
demo site
(Get the code!)
confirming this problem with PhpMyAdmin :
phpmyadmin is utf-8, my database was converted from utf-8 at import, but when i use phpmyadmin to insert values in any tables, they are "automagically" converted to latin1.
all default COLLATE values are latin1-swedish in mysql, but i didn't set this anywhere (i'm using utf-8 everywhere possible, and speak french, so in worst case it would have been latin-1-french, or something like that).
using recent dapper, mysql-server 5.0.21-3 .