ansi mysql_MySQL的ANSI和Unicode驱动程序之间的区别

On choosing Data Source under ODBC (64-Bit) on Windows, i get two available options of MySQL Database:

MySQL ODBC 5.3 ANSI Driver

MySQL ODBC 5.3 Unicode Driver

What are the difference between these two?

解决方案

Firstly I should say that I don't use MySQL but I do know about ODBC Drivers. In ODBC there are different APIs for unicode and ansi. The ansi APIs end in A and the unicode APIs end in W (e.g., SQLPrepareA and SQLPrepareW). The ansi APIs accept bytes/octets for character strings and hence can only handle chrs 0-255. The unicode APIs accept SQLWCHARs which are 2 byte UCS-2 encoded unicode codepoints (newer MS SQL Server versions can handle UTF16 encoded strings) and so can handle approximately the first 65000 codepoints in unicode.

So if