• Supported only for MySQL 4.0.2 or higher.

• If a JConnector version prior to 5.1.28 is used, fractional seconds returned from CAST STRING to TIMESTAMP are erroneously offset three decimal places to the right.

• Casting as a whole number converts NULL values to zero, so whole numbers cannot be pushed safely.

• When casting a NULL value for a TIMESTAMP column as VARCHAR, MySQL might return either NULL or ‘0000-00-00 00:00:00’ (depending on the default-value setting for the column in the data source). TDV server (no push) always returns NULL.

• Depending on MySQL server-side settings (TRADITIONAL vs. STRICT), can return data and warnings or no data and error when casting incompatible data types.