Forums / Install & configuration / Database character set issue

Database character set issue

Next topic

Author	Message
Aaron Carlino	Friday 23 February 2007 9:06:59 am I'm installing ezPublish 3.6.11 (the latest version that works with PHP 4.3) and I've gotten to following screen: Site details This page lets you modify information about the site you've chosen to install. In addition, it also lets you choose a database for the site. 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. When I go into PHPMyAdmin, I don't have ISO as a choice. I've tried changing it to UTF, but it doesn't work. What does EZPublish want from me? -Aaron MYSQL 4.1 PHP 4.3.9
Claudia Kosny	Friday 23 February 2007 12:53:01 pm Hi Aaron As the name of the used charset is missing in the error message I think that you are experiencing this bug http://issues.ez.no/6545 (read Vittals comment for the solution). Here some info about character sets in MySQL: http://dev.mysql.com/doc/refman/4.1/en/charset-we-sets.html says that: MySQL's latin1 is the same as the Windows cp1252 character set. This means it is the same as the official ISO 8859-1 ... Not sure whether eZ 3.6 is smart enough to recognise this though - just try it out if necessary. Good luck Claudia
Aaron Carlino	Tuesday 27 February 2007 7:58:39 am Perfect!!! Thank you!
Betsy Gamrat	Tuesday 27 February 2007 7:29:44 pm I had the same question, thank you Claudia. :)