Forums / Install & configuration / Pb installing eZ : character encoding conflict with MySQL

Pb installing eZ : character encoding conflict with MySQL

Next topic

Author	Message
Michel Roche	Thursday 20 April 2006 6:50:42 am Hi, I'm attempting to install eZ Publish in a provider's space, so I only have acces to the tool he let me to administrate PHP and MySQL, that is PHPMyAdmin for this concern. When the eZ installer comes to the point of selecting the database, it finds the right one but complains when I click on the Next button because : <i>The database cannot be used, it uses the character set iso-8859-1 which is different from the requested charset utf-8.</i> I swear I defined all formats to utf-8 in the db, either for the data storage and for the collating datas. So I don't understand what I'm missing, or if it's a bug (either from eZ, PhpMyAdmin, MySql or my provider) that I should work around. Thanks a lot for your help. Michel Roche occasionally webmaster ;-) Vercors, France.
Łukasz Serwatka	Sunday 23 April 2006 11:02:59 pm Hello, What is your MySQL version? Support for Unicode is available since version 4.1 or higer. Use this query to setup database in Unicode: CREATE DATABASE `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; You can execute it from phpmyadmin. Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Hakim Bouras	Thursday 15 June 2006 4:39:39 am Hello, It happens to me too when I tred to install ezPublish 3.8 selecting 2 languages. The only way I had to finish my installation was to select only one language. Hakim

Author

Message

Thursday 20 April 2006 6:50:42 am

Hi,
I'm attempting to install eZ Publish in a provider's space, so I only have acces to the tool he let me to administrate PHP and MySQL, that is PHPMyAdmin for this concern.

When the eZ installer comes to the point of selecting the database, it finds the right one but complains when I click on the Next button because :

<i>The database cannot be used, it uses the character set iso-8859-1 which is different from the requested charset utf-8.</i>

I swear I defined all formats to utf-8 in the db, either for the data storage and for the collating datas.
So I don't understand what I'm missing, or if it's a bug (either from eZ, PhpMyAdmin, MySql or my provider) that I should work around.

Thanks a lot for your help.

Michel Roche
occasionally webmaster ;-)

Vercors, France.

Łukasz Serwatka

Sunday 23 April 2006 11:02:59 pm

Hello,

What is your MySQL version? Support for Unicode is available since version 4.1 or higer. Use this query to setup database in Unicode:

CREATE DATABASE `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

You can execute it from phpmyadmin.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Hakim Bouras

Thursday 15 June 2006 4:39:39 am

Hello,

It happens to me too when I tred to install ezPublish 3.8 selecting 2 languages. The only way I had to finish my installation was to select only one language.

Hakim