utf8 problem - community.ez.no

Friday 24 February 2006 12:39:03 pm - 3 replies

Modified on Friday 24 February 2006 12:39:42 pm by vicat olivier

3 replies

Author	Message
Ł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

Author

Message

Ł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

You must be logged in to post messages in this topic!