Chinese word becomes messy code when using fastinsert for the MySql
1 view (last 30 days)
Show older comments
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 Comments
Walter Roberson
on 26 Mar 2014
Could you show us the original encoding, and what it becomes? You could print in hex, such as
sprintf('%04x ', CharacterArray)
Walter Roberson
on 26 Mar 2014
Is this the same question as http://www.mathworks.co.uk/matlabcentral/answers/123221-matlab-mysql-how-to-fix-it ?
Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!