Forums / Install & configuration / Database character set issue

"Please Note:
  • At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
  • This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Database character set issue

Author Message

Aaron Carlino

Friday 23 February 2007 9:06:59 am

I'm installing Exponential 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 Exponential 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.

:)