Backported “change user” and “reset server state” functionality from 3.1 branch, to enable clients of MysqlConnectionPoolDataSource to reset server state on getConnection() on a pooled connection.

Made StringRegressionTest 4.1-unicode aware. (Bug #3520)

Use SET character_set_results during initialization to enable any charset to be returned to the driver for result sets. (Bug #2670)

Fixed regression in PreparedStatement.setString() and eastern character encodings. (Bug #3520)

Don't truncate BLOB or CLOB values when using setBytes() and setBinary/CharacterStream(). (Bug #2670)

Map duplicate key and foreign key errors to SQLState of 23000.

Allow java.util.Date to be sent in as parameter to PreparedStatement.setObject(), converting it to a Timestamp to maintain full precision. . (Bug #103)

Add unsigned attribute to DatabaseMetaData.getColumns() output in the TYPE_NAME column.

Not specifying database in URL caused MalformedURL exception. (Bug #3554)

Added failOverReadOnly property, to enable the user to configure the state of the connection (read-only/writable) when failed over.

Dynamically configure character set mappings for field-level character sets on MySQL-4.1.0 and newer using SHOW COLLATION when connecting. (Bug #2670)

Map binary character set to US-ASCII to support DATETIME charset recognition for servers >= 4.1.2. (Bug #2670)

Inconsistent reporting of data type. The server still doesn't return all types for *BLOBs *TEXT correctly, so the driver won't return those correctly. (Bug #3570)

Auto-convert MySQL encoding names to Java encoding names if used for characterEncoding property. (Bug #3554)

Backport documentation tooling from 3.1 branch.

Use junit.textui.TestRunner for all unit tests (to enable them to be run from the command line outside of Ant or Eclipse). (Bug #3554)

Renamed StringUtils.escapeSJISByteStream() to more appropriate escapeEasternUnicodeByteStream(). (Bug #3511)

Use charsetnr returned during connect to encode queries before issuing SET NAMES on MySQL >= 4.1.0. (Bug #2670)

StringUtils.escapeSJISByteStream() not covering all eastern double-byte charsets correctly. (Bug #3511)

DBMD.getSQLStateType() returns incorrect value. (Bug #3520)

Add helper methods to ResultSetMetaData (getColumnCharacterEncoding() and getColumnCharacterSet()) to permit end users to see what charset the driver thinks it should be using for the column. (Bug #2670)

Don't escape SJIS/GBK/BIG5 when using MySQL-4.1 or newer.

Added encoding names that are recognized on some JVMs to fix case where they were reverse-mapped to MySQL encoding names incorrectly. (Bug #3554)

Only set character_set_results for MySQL >= 4.1.0. (Bug #2670)

Return creating statement for ResultSets created by getGeneratedKeys(). (Bug #2957)

UpdatableResultSet not picking up default values for moveToInsertRow(). (Bug #3557)

Allow url parameter for MysqlDataSource and MysqlConnectionPool DataSource so that passing of other properties is possible from inside appservers.