MySQL Forums
Forum List  »  PHP

Re: strange unicode problem - big5 to utf8 in MySQL Windows (win32)
Posted by: Jerry Lee
Date: June 15, 2005 12:45AM

As I tested, only all the double-byte charset is not transformed correctly in Mysql/Windows, I did tests:

big5 <-> utf- => wrong
big5 <-> gb2312 => wrong
big5 <-> ucs-2 => wrong
big5 <-> utf-7 => correct

The tests I did show that only utf-7 could be transformed back and forth correcly.
But utf-7 is stored as ASCII characters in Mysql, and is pretty long. (about twice as long as big5)

Does anybody has solution on this?

Jerry-
http://fonsen.zhtw.com/

Options: ReplyQuote


Subject
Written By
Posted
Re: strange unicode problem - big5 to utf8 in MySQL Windows (win32)
June 15, 2005 12:45AM


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.