Can't select/inserting/updating some Chinese Character.
Posted by: Leung Data
Date: June 17, 2005 01:05AM

Dear All
I'm facing a problem:
When selecting/inserting/updating record in mySQL, some Chinese words couldn't be selected/stored correctly. As when encoding Chinese in the mySQL server, some byte will contains "|" (ie. reserve as "or" in the mySQL server) or "\" (ie. reserve as reference in the mySQL server, same as ' in the MSSQL server).

for example: 誠 will be encoded as Õ\
運 will be encoded as ß\
鋅 will be encoded as ä\

It seems mySQL server not cater multi-byte character currently.

And I'm looking for selecting / inserting / updating simplified character & trad character
record. And I had been complie the MySQL server with gb / big5 / utf8 already .

Hope anyone can get some help on me .

Thanks .

Options: ReplyQuote

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.