Wrong character set detected while installing DB

Previous topic

Install & configuration

Next topic

Author	Message
mix mac	Saturday 24 April 2010 3:53:07 am Hi! This is my first ezP installation. I've borrowed the 4.3.0 package. Everything runs smoothly through the install wizard until the Step 9 (DB details). As said in the doc: “It is required that the database uses UTF-8 as character set.” [URL=http://img153.imageshack.us/i/capturedcran20100424170.png/][IMG]http://img153.imageshack.us/img153/5455/capturedcran20100424170.png[/IMG][/URL] Which is the case, as shown in the screenshot. But the Wizard still argues that the DB has been created using a [iso-8859-1] character set. Any idea to help me solve this pb? Thanks! m
mix mac	Saturday 24 April 2010 4:27:01 am I've found the problem. The DB was created with a utf8 caracter set. But the collation was set to latin1_swedish_ci. I've updated this to utf8-unicode_ci through phpMyAdmin. Sorry for the noise! m
Nicolas Pastorino	Saturday 24 April 2010 9:17:11 am Hi ! Good to read you found your problem. You may now want to mark the forum thread as solved (small ticker at the leff of the topic's title above). Ow, and welcome aboard the eZ Community ! Cheers, -- Nicolas Pastorino Director Community - eZ Member of the Community Project Board eZ Publish Community on twitter: http://twitter.com/ezcommunity t : http://twitter.com/jeanvoye G+ : http://plus.tl/jeanvoye

Author

Message

mix mac

Saturday 24 April 2010 3:53:07 am

Hi!

This is my first ezP installation. I've borrowed the 4.3.0 package.

Everything runs smoothly through the install wizard until the Step 9 (DB details).

As said in the doc: “It is required that the database uses UTF-8 as character set.”

[URL=http://img153.imageshack.us/i/capturedcran20100424170.png/][IMG]http://img153.imageshack.us/img153/5455/capturedcran20100424170.png[/IMG][/URL]

Which is the case, as shown in the screenshot.

But the Wizard still argues that the DB has been created using a [iso-8859-1] character set.

Any idea to help me solve this pb?

Thanks!

mix mac

Saturday 24 April 2010 4:27:01 am

I've found the problem. The DB was created with a utf8 caracter set. But the collation was set to latin1_swedish_ci. I've updated this to utf8-unicode_ci through phpMyAdmin.

Sorry for the noise!

Nicolas Pastorino

Saturday 24 April 2010 9:17:11 am

Hi !

Good to read you found your problem. You may now want to mark the forum thread as solved (small ticker at the leff of the topic's title above).

Ow, and welcome aboard the eZ Community !

Cheers,

--
Nicolas Pastorino
Director Community - eZ
Member of the Community Project Board

eZ Publish Community on twitter: http://twitter.com/ezcommunity

t : http://twitter.com/jeanvoye
G+ : http://plus.tl/jeanvoye

eZ debug

Timing:	Jan 30 2025 00:44:06
Script start
Timing:	Jan 30 2025 00:44:06
Module start 'layout'
Timing:	Jan 30 2025 00:44:06
Module start 'content'
Timing:	Jan 30 2025 00:44:07
Module end 'content'
Timing:	Jan 30 2025 00:44:07
Script end

Main resources:

Total runtime	1.3531 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0051	588.3828	151.2422
Module start 'layout'	0.0051	0.0035	739.6250	36.7109
Module start 'content'	0.0086	1.3437	776.3359	474.4063
Module end 'content'	1.3523	0.0008	1,250.7422	11.9531
Script end	1.3531		1,262.6953

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	0.2216	16	0.0002
Check MTime	0.0012	0.0902	16	0.0001
Mysql Total
Database connection	0.0010	0.0726	1	0.0010
Mysqli_queries	1.3115	96.9230	57	0.0230
Looping result	0.0005	0.0393	55	0.0000
Template Total	1.3172	97.3	2	0.6586
Template load	0.0021	0.1556	2	0.0011
Template processing	1.3151	97.1877	2	0.6575
Template load and register function	0.0002	0.0112	1	0.0002
states
state_id_array	0.0022	0.1601	1	0.0022
state_identifier_array	0.0011	0.0814	2	0.0006
Override
Cache load	0.0018	0.1311	23	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.0632	2	0.0004
Fetch class attribute name	0.0015	0.1098	4	0.0004
XML
Image XML parsing	0.0005	0.0388	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0006	4	0.0000
General
dbfile	0.0008	0.0578	16	0.0000
String conversion	0.0000	0.0006	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 9 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs