utf8 problem

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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.