mysql odbc ansi_MYSQL Connector/ODBC [Mysql ODBC驱动版本的 ANSI 和 UNICODE两个版本的区别]

本文链接：https://blog.csdn.net/weixin_39533280/article/details/113160815

MySQL Connector/ODBC 提供 ANSI 和 Unicode 两种驱动版本。Unicode 驱动支持多种字符集，适合多语言环境，而 ANSI 驱动针对有限字符集提供最优性能。版本5.2的Unicode驱动增加了对SQL_WCHAR和Unicode登录配置的支持，而ANSI版本则优化了64位Windows平台的性能。随着5.2版提供双驱动，建议尽快升级。

摘要由CSDN通过智能技术生成

Connector/ODBC Versions

These are the versions of Connector/ODBC that are currently available:

Connector/ODBC 5.2, currently in GA status, upgrades the ANSI driverof Connector/ODBC 3.51 to the 5.x code base. It also includes new features, such as enabling server-side prepared statements by default. At installation time, you can choose theUnicode driverfor the broadest compatibility with data sources using various character sets, or the ANSI driver for optimal performance with amore limited range of character sets. It works with MySQL versions 4.1.1 and higher.

MYSQL Connector/ODBC 提供了两个版本，一个是 ANSI driver 和 Unicode driver 两个版本。

Unicode driver 版本提供了更多字符集的支持，也就是提供了多语言的支持。而ANSI driver 版本是只针对有限的字符集的范围。

Connector/ODBC 5.1, now superseded by 5.2, is a partial rewrite of the of the 3.51 code base, and is designed to work with MySQL versions 4.1.1 and newer.

Connector/ODBC 5.1 also includes the following changes and improvements over the 3.51 release:

Improved support on Windows 64-bit platforms.

Full Unicodesupport at the driver level. This includes support for theSQL_WCHARdata

type, and support for Unicode login, password and DSN configurations. For more information, seeMicrosoft

Knowledgebase Article #716246.

Support for theSQL_NUMERIC_STRUCTdata

type, which provides easier access to the precise definition of numeric values. For more information, seeMicrosoft

Knowledgebase Article #714556

Native Windows setup library. This replaces the Qt library based interface for configuring DSN information within the ODBC Data Sources application.

Support for the ODBC descriptor, which improves the handling and metadata of columns and parameter data. For more information, seeMicrosoft

Knowledgebase Article #716339.

Connector/ODBC 3.51 is the current release of the 32-bit ODBC driver, also known as the MySQL ODBC 3.51 driver. Connector/ODBC 3.51 has support for ODBC 3.5x specification level 1 (complete core API + level 2 features) to continue to provide all functionality

of ODBC for accessing MySQL.

With MySQL Connector/ODBC 5.2 now offering both ANSI and Unicode drivers, you should expect to upgrade relatively soon.

The manual for versions of Connector/ODBC older than 5.2 can be located in the corresponding binary or source distribution. Please note that versions of Connector/ODBC earlier than the 3.51 revision were not fully compliant with the ODBC specification.

Note

From this section onward, the primary focus of this guide is the Connector/ODBC 5.2 driver.

Note

Version numbers for MySQL products are formatted as X.X.X. However, Windows tools (Control Panel, properties display) may show the version numbers as XX.XX.XX. For example, the official MySQL formatted version number 5.0.9 may be displayed by Windows tools

as 5.00.09. The two versions are the same; only the number display format is different.