MySQL db with UTF-8 charset

[thewolf]

Hi,

We're using Plesk 8.1 on Red Hat Enteprise Linux 4 with PHP 4.3.9 and MySQL 4.1.x.

It looks like Plesk 8.1 will use UTF-8 as charset when creating new MySQL dbs, instead of the usual ISO-8859-1 used by Plesk 7.5 and 8.0.

Is there a way to force Plesk 8.1 to revert to the older behaviour and use ISO-8859-1 as charset for new MySQL dbs?

We've installed Zen Cart 1.3.7.1 (www.zen-cart.com) on the server.

So far the Zen Cart installation is working fine, but we're afraid that something may break in the future (especially when handling non-ASCII characters) due to the fact that the Zen Cart PHP application is using ISO-8859-1 as charset while the MySQL db is using UTF-8.

Should we re-install ZC using an ISO-8859-1 db instead to be on the safe side?

Or is it safe to keep the current setup?

Thanks.

 

[Amin Taheri]

UTF-8 should be fine for most people, but read up on the types and make sure that you cant use UTF-8 before you change it up.

Also, are you sure its plesk that is setting the charset, or is it a server side default in mysql itself (which you can change in mysql)?