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
|
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/
|