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".