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

eZ debug

Timing:	Jan 31 2025 06:20:29
Script start
Timing:	Jan 31 2025 06:20:29
Module start 'layout'
Timing:	Jan 31 2025 06:20:29
Module start 'content'
Timing:	Jan 31 2025 06:20:29
Module end 'content'
Timing:	Jan 31 2025 06:20:29
Script end

Main resources:

Total runtime	0.0150 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0052	588.4141	151.2422
Module start 'layout'	0.0052	0.0028	739.6563	36.6953
Module start 'content'	0.0081	0.0053	776.3516	90.3750
Module end 'content'	0.0134	0.0016	866.7266	33.9922
Script end	0.0149		900.7188

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	17.2630	14	0.0002
Check MTime	0.0011	7.5045	14	0.0001
Mysql Total
Database connection	0.0007	4.8442	1	0.0007
Mysqli_queries	0.0026	17.5131	3	0.0009
Looping result	0.0000	0.1004	1	0.0000
Template Total	0.0011	7.6	1	0.0011
Template load	0.0009	5.8462	1	0.0009
Template processing	0.0003	1.7634	1	0.0003
Override
Cache load	0.0006	3.8279	1	0.0006
General
dbfile	0.0003	1.8494	8	0.0000
String conversion	0.0000	0.0589	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs