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
SHOW FULL COLUMNS on MySQL 8 returns 'blob' for 'Type' and 'Default'
Re: SHOW FULL COLUMNS on MySQL 8 returns 'blob' for 'Type' and 'Default'
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:
You can use Data Type Mapping for the needed columns. For example:
Code: Select all
MyQuery.DataTypeMap.AddFieldNameRule('Type', ftString);
MyQuery.DataTypeMap.AddFieldNameRule('Default', ftString);
Re: SHOW FULL COLUMNS on MySQL 8 returns 'blob' for 'Type' and 'Default'
In MySQL Workbench, using a MySQL 8 database, 'type', 'default' and 'comment' is listed as TEXT, not as a binary BLOB, with charset utf8mb4.For TYPE and DEFAULT fields, the MySQl 8 server will return a BINARY flag and MYSQL_TYPE_BLOB field
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?
Re: SHOW FULL COLUMNS on MySQL 8 returns 'blob' for 'Type' and 'Default'
Thank you for the information. We have reproduced the issue and it will be fixed in the next build.
Re: SHOW FULL COLUMNS on MySQL 8 returns 'blob' for 'Type' and 'Default'
Hello Viktor,
That's good to hear - looking forward to it.
That's good to hear - looking forward to it.
Re: SHOW FULL COLUMNS on MySQL 8 returns 'blob' for 'Type' and 'Default'
Thank you for the interest to our product.
Feel free to contact us if you have any further questions about our products.
Feel free to contact us if you have any further questions about our products.