Devart Forums

Hi there,

Is there any reason why the latest version of MyDAC returns BLOBs for the columns 'type' and 'default' if I issue a SHOW FULL COLUMNS-statement?

These used to be returned as (var)char.

With regards,

Martijn Tonies

This behavior is correct. The fields are created based on the information sent by the MySQL server and if the server returns a BINARY flag for a field of the MYSQL_TYPE_BLOB type, a field of the ftBLOB type will be created. For TYPE and DEFAULT fields, the MySQl 8 server will return a BINARY flag and MYSQL_TYPE_BLOB field.
You can use Data Type Mapping for the needed columns. For example:

For TYPE and DEFAULT fields, the MySQl 8 server will return a BINARY flag and MYSQL_TYPE_BLOB field

In MySQL Workbench, using a MySQL 8 database, 'type', 'default' and 'comment' is listed as TEXT, not as a binary BLOB, with charset utf8mb4.

In version 5.7, these are returned as TEXT, 'comment' is returned as VARCHAR, all with char set utf8.

How come you're returning it as a binary blob?

Thank you for the information. We have reproduced the issue and it will be fixed in the next build.

Hello Viktor,

That's good to hear - looking forward to it.

Thank you for the interest to our product.
Feel free to contact us if you have any further questions about our products.