Database character set issue

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.

:)

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.