Forums / Install & configuration / Characterset Install Conflict

Characterset Install Conflict

Author Message

Jim Rea

Monday 30 January 2006 4:41:27 pm

I have read a great deal on these forums regarding the characterset not being accepted during installation, to no avail. I still cannot get past this check in the installation script.

I submitted the following MySQL query which was successfully executed:

ALTER DATABASE `ezpub` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

The database characterset reads as being set to utf8
I have selected eng-US as the language

Still I cannot get past this problem in the script.

The MySQL manual indicates that the statement above will change the default character set, and it appears to have done so. I do not understand why the check continues to fail.

Help from anyone would be greatly appreciated

Xavier Dutoit

Tuesday 31 January 2006 12:11:16 am

Hi,

Could you detail the problem you experience ? error message , at what stage...

Also, tell us the versions you have (mysql+ez).

X+

http://www.sydesy.com

Jim Rea

Wednesday 01 February 2006 12:48:33 am

Hi Xavier,

I am running PHP 4.3.10 and MySQL 3.23.58

My settings are a little different from my original post as I am continuing to experiment. I am in the installation script, having selected eng-GB as the language. At the Site Details screen after selecting the database mentioned above I get the following message:

Warning

The database cannot be used, it uses the character set which is different from the requested charset iso-8859-1, iso-8859-2, iso-8859-3, iso-8859-4, iso-8859-9, iso-8859-10, iso-8859-13, iso-8859-14, iso-8859-15, windows-1252, windows-1250, cp850, dec-mcs.

The current character set is (on this iteration) latin1 latin1_bin - which I understand from other postings on this forum is aliased to iso-8859-1.

Thanks for your help

arran holloway

Friday 16 June 2006 8:16:29 am

I am also having exactly the same problems as reported above, has anybody found a solution to this problem yet?

My database name uses _-_ in the middle of it (a name format imposed by hosting) other people have reported problems with this that may be related to the characterset problem.

Björn [email protected]

Friday 16 June 2006 9:55:53 am

Well it is very easy.... you need mysql 4.1 and above

ALTER DATABASE `ezpub` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

won't execute below 4.1, meaning 4.1 onyl has real unicode support

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/