peterlaursen wrote on Dec 5 2006, 11:29 AM:
Please search a little before asking questions!
This has been answered quite a lot of times before!
Try in the connections manger to choose a chinese non-unicode character set (like 'big5') – and not utf8 – as the character set for the connection. You should be able the display and work with Chinese like that.
Hello,
In fact, I did do my best to read all of the FAQs related to the “problem” on the site, which may not fit in my situation. So I thought this is a bug.
In a word, my table and columns are specified UTF-8, data is UTF-8 (input correctly from other program), connection manager is set to UTF-8, on Chinese Windows XP , the Chinese data shown on screen become garbage, let alone inputting from webyog.
I don't see anything wrong with this kind of intuitive all-UTF8 setting, and it is okay with MySQL 5.0, but not with 4.1.
Setting connection charset in connection manager to Big5 can make data input correctly, but they become Big5, not UTF-8. And BTW, setting connection charset in connection manager to Big5/UTF8/whatever charsets doens't make my UTF-8 data in the table (input correctly from other program) display correctly in webyog with MySQL 4.1 either.
Well..if this is my problem , then never mind… Thanks for you help.
