Forums / Install & configuration / utf8 problem
vicat olivier
Friday 24 February 2006 12:39:03 pm
Hi allI've problems with utf8.
In phpmyadmin panel, what are the good settings?
i've this settings :
MySQL charset: UTF-8 Unicode (utf8)MySQL connection collation: ??????
Is there something to do with collate?ALTER DATABASE `toto` DEFAULT CHARACTER SET ???? COLLATE ????
Łukasz Serwatka
Tuesday 28 February 2006 12:29:38 am
For MySQL >= 4.1 run:
CREATE DATABASE `toto` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Sandra Parente
Monday 06 March 2006 7:32:12 am
I'm having problems importing a mysql database with content stored in latin1 to a server running utf-8: all the text following a special character disappears, even in titles. I've already changed the charset in i18n.ini, but it affects obviously only the newly stored content.Is there some script I can launch before importing the database?
Sandra Parente www.netbliss.it
Georg Franz
Monday 06 March 2006 8:15:07 am
Hi Sandra,
have a look at:
http://ez.no/community/forum/developer/howto_convert_database_from_charset_latin_1_to_utf_8/re_howto_convert_database_from_charset_latin_1__3
You are getting more infos here:http://ez.no/content/advancedsearch?&SearchText=utf-8+conversion+mysql&SubTreeArray%5B%5D=2
Best wishes, Georg. -- http://www.schicksal.com Horoskop website which uses eZ Publish since 2004