Chinese word becomes messy code when using fastinsert for the MySql
1 回表示 (過去 30 日間)
古いコメントを表示
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!
2 件のコメント
Walter Roberson
2014 年 3 月 26 日
Could you show us the original encoding, and what it becomes? You could print in hex, such as
sprintf('%04x ', CharacterArray)
Walter Roberson
2014 年 3 月 26 日
Is this the same question as http://www.mathworks.co.uk/matlabcentral/answers/123221-matlab-mysql-how-to-fix-it ?
回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Database Toolbox についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!