Charset/Collation problem
Posted by: Imię Nazwisko
Date: November 14, 2010 07:51PM


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

Options: ReplyQuote

Written By
Charset/Collation problem
November 14, 2010 07:51PM
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.