Devart Forums

Posted: **Tue 13 Oct 2009 07:05**

Hi,

I create tables with column-type "longtext" and "longblob".

If I create a query with have both columns in result set, I get fieldtype TFieldType.ftMemo for both.

Is there a possibility to get the correct type on the Dataset-Level? I need this because I need different behaviour on "real blobs" an "big text-fields".

Thanks

Bernhard

Posted: **Mon 26 Oct 2009 09:25**

MyDAC maps the longtext MySQL type to the ftMemo field type and the longblob type to ftBlob.
Please, check that you have the latest MyDAC build (5.90.0.52).

Posted: **Mon 26 Oct 2009 11:06**

Thanks for the answer,

we currently use a older version.
Can you give me a hint in which Unit/Methode the relevant assigning is done, so I can modify the older version of DAC for MyDAC (we also have the newest version but not time to switch to it).

Posted: **Mon 26 Oct 2009 13:03**

Look at the ConvertMySQLTypeToInternalFormat procedure in the MyClasses unit.

Devart Forums

How to check if a column is "longtext" or "longblob"

How to check if a column is "longtext" or "longblob"