I need someones help on DB connections and encoding

Scriptcase 9 General
#1

Ok here is scenerio…this is from beginning of time… (remember still on scriptcase 6) so no pdo connection available

Dev connections for database are set up as mysql transactional when i created in prod after upload i didnt set as transactional just mysql.

didnt stop anything from working

also the client_encoding on the dev vs what in prod also different on some connections…
those should be the same as on the database itself correct?
will changing them effect anything?

so my question is can i change the prod connections to mysql transactional and change the encoding to match database on prod
and dev to match and have it not blow up my anything?

Kev

ps may throw up on forum but dont get answers usually from anyone…

again 2 cents appreciated…

#2

The database encoding should preferably have the same encoding as the web site (and vice versa).
But conversions are being done but in version 6 you may see characters are not properly converted (various special characters).
Changing the encoding does have an effect.
Say you have ? in your database then it gets converted to the web charset which may be ? (just an example) but your website also does a translation.

And yes you can change the encoding normally. But you may need to export and reimport the data…

Changing the database (make backups first!!!) can be done: http://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8