utf8 problem

Next topic

Author	Message
vicat olivier	Friday 24 February 2006 12:39:03 pm Hi all I'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