Charset/Collation problem
Hi,
I have a problem with collations in mysql. I've created a DB on my local machine and I have secured that all my tables use the same collation/charset. Now when I deploy this db to the production, accent chars of strings are displayed wrong and it's obvious it's DB fault not php or whatever.
Now I've read that there are 3 levels of collation: Server, DB and Table. I do have control over last 2 only and both are set to the same values on both servers. Conclusion is that servers has different collations or mysql is bugged (in which I doubt). So please can someone tell me what steps should I take to make my db run the same no matter of the server it will be on? Is it possible to achive in mysql? I'm expierienced MS SQL server developer and I have never ever had any such problems there...
Subject
Views
Written By
Posted
Charset/Collation problem
3099
November 14, 2010 07:51PM
1304
November 16, 2010 01:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.