Use excel mysql, get the whole table data, access to the article 400 + data, the program terminates and error: unknown failure when converting a character to the result character set


A character set has a problem is suspected, but why the same table before 400 data can be normal access to
Remaining in the same database table, can get the whole table data

Have a great god met excuse me?

CodePudding user response:

Resolved

Keywords: character set

I suddenly thought of place to set the character set is adding in the ODBC data source, I chose the ANSI
But the database is utf-8, should choose the unicode character set data source

To build a data source, after problem solving