Chinese word becomes messy code when using fastinsert for the MySql

I need to read some records from a table in mysql and then write into another table.

First, I use the code to read records:

    sql = 'select * ....';
    cursor = fetch(exec(conn, sql));

The code can fetch the data, and the chinese field is very clearly. After this, I need to write the data into another table.

    cursor{end+1} = 'test';
    fastinsert(conn, tablename, colname, cursor);

The code can write the data into the specified table. BUT the chinese words become messy code. I don't know why.

What's more. I have tried:

   1) insert a record using phpmyadmin manually,  and the chinese word is clearly.
   2) change the default character set of mysql to 'utf-8',but the error exists as well

So,I guess whether I need to do some character set relevant operations or not before insertion. And how to do it? :-)

Any suggestion will be thankful!

[Walter Roberson]

Could you show us the original encoding, and what it becomes? You could print in hex, such as

sprintf('%04x ', CharacterArray)

[Walter Roberson]

Is this the same question as http://www.mathworks.co.uk/matlabcentral/answers/123221-matlab-mysql-how-to-fix-it ?