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

Bernhard Geyer · Post by **Bernhard Geyer** » 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

Dimon · Post by **Dimon** » 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).

Bernhard Geyer · Post by **Bernhard Geyer** » 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).

Dimon · Post by **Dimon** » Mon 26 Oct 2009 13:03

Look at the ConvertMySQLTypeToInternalFormat procedure in the MyClasses unit.