Purpose

Determines the JDBC data type the driver uses to describe and return data that MySQL stores as BINARY or VARBINARY. By default, the driver describes and returns data that MySQL stores as BINARY or VARBINARY as BINARY or VARBINARY values, respectively.

Valid Values

true | false

Behavior

If set to true, the driver describes and returns data that MySQL stores as BINARY or VARBINARY as CHAR or VARCHAR values, respectively.

If set to false, the driver describes and returns data that MySQL describes as BINARY or VARBINARY as BINARY or VARBINARY values, respectively.

Example

Create the following MySQL table:

CREATE TABLE binTable (col1 binary(3))

and execute the following Insert statement:

INSERT INTO binTable values('abc')

Then, set this property to true and execute the following query:

SELECT col1 FROM binTable

The driver would return the value of col1 as a CHAR value, "abc", instead of a BINARY value "616263".

Default

false

Data Type

boolean