Devart Forums

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

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.