Affected by the charset problem during install....

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

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