LongText is blob?

upscene · Post by **upscene** » Mon 26 Apr 2010 10:05

Hi,

I'm a bit puzzled -- on the "information_schema" database (MySQL 5), I get "ROUTINES.BODY" (or TRIGGERS.ACTION_STATEMENT) returned as a ftBlob, while it has a LongText column with UTF8 charset.

Why isn't this a TWideMemoField? How should I know this is a text fields instead of byte blob field? And what encoding it uses?

My TMyConnection has UseUnicode set to True, Delphi 2009, latest version of MyDAC. I noticed older versions have the same issue.

UPDATE!
It seems there's another issue and I'm looking at the wrong query - no problem with LongText.

With regards,

Martijn Tonies
Upscene Productions

Dimon · Post by **Dimon** » Mon 26 Apr 2010 10:22

I can not reproduce the problem.
TMyConnection maps the LONGTEXT MySQL type to TWideMemoField when MyConnection.Options.UseUnicode is equal to True.
Please, specify exact steps to reproduce the problem.

upscene · Post by **upscene** » Mon 26 Apr 2010 10:24

Dimon wrote:I can not reproduce the problem.
TMyConnection maps the LONGTEXT MySQL type to TWideMemoField when MyConnection.Options.UseUnicode is equal to True.
Please, specify exact steps to reproduce the problem.

Hello Dimon,

I just updated my original post, thanks for the prompt reply, it seems the problem lies elsewhere.