Platform specific notes:
The HP-UX 11.23 IA64 binary package does not include the GUI bits because of problems building Qt on that platform.
There is no binary package for Mac OS X on 64-bit PowerPC because Apple does not currently provide a 64-bit PowerPC version of iODBC.
Binary packages for Sun Solaris are now available as
PKGpackages.Binary packages as disk images with installers are now available for Mac OS X.
A binary package without an installer is available for Microsoft Windows x64 Edition. There are no installer packages for Microsoft Windows x64 Edition.
Functionality added or changed:
Incompatible Change: The
FLAG_DEBUGoption was removed.When connecting to a specific database when using a DSN, the system tables from the
mysqldatabase are no longer also available. Previously, tables from the mysql database (catalog) were listed asSYSTEM TABLESbySQLTables()even when a different catalog was being queried. (Bug#28662)Installed for Mac OS X has been re-instated. The installer registers the driver at a system (not user) level and makes it possible to create both user and system DSNs using the MySQL Connector/ODBC driver. The installer also fixes the situation where the necessary drivers would bge installed local to the user, not globally. (Bug#15326, Bug#10444)
MySQL Connector/ODBC now supports batched statements. To enable cached statement support, you must switch enable the batched statement option (
FLAG_MULTI_STATEMENTS, 67108864, or Allow multiple statements within a GUI configuration). Be aware that batched statements create an increased chance of SQL injection attacks and you must ensure that your application protects against this scenario. (Bug#7445)The
SQL_ATTR_ROW_BIND_OFFSET_PTRis now supported for row bind offsets. (Bug#6741)The
TRACEandTRACEFILEDSN options have been removed. Use the ODBC driver manager trace options instead.
Bugs fixed:
When using a table with multiple
TIMESTAMPcolumns, the finalTIMESTAMPcolumn within the table definition would not be updateable. Note that there is still a limitation in MySQL server regarding multipleTIMESTAMPcolumns . (Bug#9927) (Bug#30081)Fixed an issue where the myodbc3i would update the user ODBC configuration file (
~/Library/ODBC/odbcinst.ini) instead of the system/Library/ODBC/odbcinst.ini. This was caused because myodbc3i was not honoring thesandumodifiers for the-dcommand-line option. (Bug#29964)Getting table metadata (through the
SQLColumns()would fail, returning a bad table definition to calling applications. (Bug#29888)DATETIMEcolumn types would returnFALSEin place ofSQL_SUCCESSwhen requesting the column type information. (Bug#28657)The
SQL_COLUMN_TYPE,SQL_COLUMN_DISPLAYandSQL_COLUMN_PRECISIONvalues would be returned incorrectly bySQLColumns(),SQLDescribeCol()andSQLColAttribute()when accessing character columns, especially those generated throughconcat(). The lengths returned should now conform to the ODBC specification. TheFLAG_FIELD_LENGTHoption no longer has any affect on the results returned. (Bug#27862)Obtaining the length of a column when using a character set for the connection of
utf8would result in the length being returned incorrectly. (Bug#19345)The
SQLColumns()function could return incorrect information aboutTIMESTAMPcolumns, indicating that the field was not nullable. (Bug#14414)The
SQLColumns()function could return incorrect information aboutAUTO_INCREMENTcolumns, indicating that the field was not nullable. (Bug#14407)A binary package without an installer is available for Microsoft Windows x64 Edition. There are no installer packages for Microsoft Windows x64 Edition.
There is no binary package for Mac OS X on 64-bit PowerPC because Apple does not currently provide a 64-bit PowerPC version of iODBC.
BIT(n)columns are now treated asSQL_BITdata wheren = 1and binary data wheren > 1.The wrong value from
SQL_DESC_LITERAL_SUFFIXwas returned for binary fields.The
SQL_DATETIME_SUBcolumn in SQLColumns() was not correctly set for date and time types.The value for
SQL_DESC_FIXED_PREC_SCALEwas not returned correctly for values in MySQL 5.0 and later.The wrong value for
SQL_DESC_TYPEwas returned for date and time types.SQLConnect()andSQLDriverConnect()were rewritten to eliminate duplicate code and ensure all options were supported using both connection methods.SQLDriverConnect()now only requires the setup library to be present when the call requires it.The HP-UX 11.23 IA64 binary package does not include the GUI bits because of problems building Qt on that platform.
Binary packages as disk images with installers are now available for Mac OS X.
Binary packages for Sun Solaris are now available as
PKGpackages.The wrong value for
DECIMAL_DIGITSinSQLColumns()was reported forFLOATandDOUBLEfields, as well as the wrong value for the scale parameter toSQLDescribeCol(), and theSQL_DESC_SCALEattribute fromSQLColAttribute().The
SQL_DATA_TYPEcolumn inSQLColumns()results did not report the correct value for date and time types.