Forums / Install & configuration / Affected by the charset problem during install....

"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".

Affected by the charset problem during install....

Previous topic

Install & configuration

Next topic

Author	Message
Benj Duval	Monday 20 March 2006 7:08:36 am Hi, i'm unfortunately affected by the charset problem during install. This is the first time ever that i encounter this problem when installing a script. Linux Ez: 3.7.4 Php: 4.4.2 Mysql: 4.1.18 My server is a dedicated server, hosted in USA. I chose as a language, English/USA and got the folowing 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." My question is: how can I know which encoding is my database using ? What should I do to convert it ? (although I don't see why I encouter a problem when using English/USA as the language). Thanks, Benj
Benj Duval	Monday 20 March 2006 8:22:30 am I logged in mysql, used the ez database and typed: mysql> ALTER DATABASE CHARACTER SET latin1; Query OK, 1 row affected (0.00 sec) mysql> ALTER DATABASE COLLATE latin1_swedish_ci; Query OK, 1 row affected (0.00 sec) Even after this, I still got the error message. Well, this is all I can do thus far. If I can't get past this, I will not be able to use the software. Cordially, Benj
Benj Duval	Monday 20 March 2006 10:36:10 am I tried to install EZ in an existing database. For some reason, I didn't had the problem with this already existing database. Maybe the problem was caused because my database name contained a "-" ? Anyway, the system is up and running. If someone encounter this problem, try removing "-" from your database name if any. Benj

Author

Message

Benj Duval

Monday 20 March 2006 7:08:36 am

Hi,
i'm unfortunately affected by the charset problem during install. This is the first time ever that i encounter this problem when installing a script.

Linux
Ez: 3.7.4
Php: 4.4.2
Mysql: 4.1.18

My server is a dedicated server, hosted in USA. I chose as a language, English/USA and got the folowing 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."

My question is: how can I know which encoding is my database using ? What should I do to convert it ?

(although I don't see why I encouter a problem when using English/USA as the language).

Thanks,
Benj

Benj Duval

Monday 20 March 2006 8:22:30 am

I logged in mysql, used the ez database and typed:

mysql> ALTER DATABASE CHARACTER SET latin1;
Query OK, 1 row affected (0.00 sec)

mysql> ALTER DATABASE COLLATE latin1_swedish_ci;
Query OK, 1 row affected (0.00 sec)

Even after this, I still got the error message.

Well, this is all I can do thus far. If I can't get past this, I will not be able to use the software.

Cordially,
Benj

Benj Duval

Monday 20 March 2006 10:36:10 am

I tried to install EZ in an existing database. For some reason, I didn't had the problem with this already existing database.

Maybe the problem was caused because my database name contained a "-" ?

Anyway, the system is up and running. If someone encounter this problem, try removing "-" from your database name if any.

Benj