May 11th, 2009
On the Orion’s Belt Translation Project we had no problems with encoding, until a player from Croatia told us that Croatian’s characters weren’t being properly persisted. I tried a direct update:
update Lang set Text = 'č,ć,ž,đ,š'
And MySQL complained with an invalid characters error. To fix this I had to change the column encoding to UTF8 (was latin1). But the application still wasn’t behaving properly. The application was sending to MySQL the following query:
update Lang set Text = 'c,c,z,d,s'
I don’t know who was transforming this (maybe the MySQL connector). To fix this I had to edit the connection string, and add the utf8 charset:
After these steps, everything worked fine.