chinese problem

[GoogleCodeExporter]

when i use assql writer chinese data into database,

the chinese data is garbled when I see it in the "MySQL Command Line Client".

but I use assql read the chinese data,put they in the datagrid,it is normal.

air application,database use utf8.

I try use a html,and servlet(all is utf8).put data in database,display data
in    

 "MySQL Command Line Client",read data and put they in the html,all is normal.

why?

Original issue reported on code.google.com by xtlinyon...@gmail.com on 3 Jun 2008 at 1:05

[GoogleCodeExporter]

I could also reproduce this problem, however, I am not sure why it is 
happening. Any
ideas?

Original comment by macl...@gmail.com on 4 Jun 2008 at 9:23

• Changed state: Accepted

[GoogleCodeExporter]

After a few more test it seems this is working ok.

Using asSQL I inserted "这是一个测试", then using the comment line 
client, select the
record, and it showed up the same in the command line viewer.

Original comment by macl...@gmail.com on 4 Jun 2008 at 9:36

[GoogleCodeExporter]

I try open a ServerSocket with java,and use flex connect it,say some chinese 
word to   
java.when i use writeUTFBytes to say chinese word to java,it's garbled in 
java.But if
I switch to use the writeMultiByte(chineseWords,"utf8"),it's normal.

I replace all the readUTFBytes and writeUTFBytes to the
readMultiByte(bytes.length,"utf8") and writeMultiByte(chineseWords,"utf8").
With no change before the only difference is that symbols do not show the same 
garbled.
(assql read and write the chinese data,put they in the datagrid,it is 
normal."MySQL
Command Line Client","MySQL Query Browser","EMS SQL Manager" display garbled).

It's frustrating:(

Original comment by xtlinyon...@gmail.com on 5 Jun 2008 at 10:43

[GoogleCodeExporter]

Original comment by macl...@gmail.com on 10 Jun 2008 at 10:05

• Added labels: Milestone-Beta2.6

[GoogleCodeExporter]

Original comment by macl...@gmail.com on 10 Jun 2008 at 11:00

• Changed state: Started

[GoogleCodeExporter]

Original comment by macl...@gmail.com on 14 Jun 2008 at 11:21

• Changed state: Fixed