How is TMyQuery.options.LongString used

ca_cruiser · Post by **ca_cruiser** » Sat 06 Oct 2007 03:06

Hello,

I had a MySql concat function truncating at 8192 chars. I set Options.LongString=False and was able to avoid string truncation.

Ae their any consequences to leaving LongString=False at all times?
e.g. performance,

I used this particualr query to retrieve single fields, one row (i.e. As a function).

JohnC

Antaeus · Post by **Antaeus** » Tue 09 Oct 2007 13:07

If the value of this property is set to False, MyDAC creates TMemoField for string fields which length is greater than 255. There should be no problems with this option set to False.
I reproduced the problem. The reason of this problem is that MySQL returns wrong field length. It is 8192. Setting the LongStrings option to False solves the problem as MyDAC does not set the field length for TMemoField.