AsString and AsWideString only returns 255-Bytes

[QEnnay]

Please how do you have defined SQL table, from where you read string data?
Column must be defined as VARCHAR with given maximum size. For example:
VARCHAR(8000); // here is limit 32767
If you need larger varchar data you must use TEXT -> MEMO

Thanks for the reply, but I mentioned above that I had tried adding the length designation to VARCHAR and it made no difference. I tried VARCHAR(2000), VARCHAR(32000), VARCHAR(max_int) and still got 255. Pretty sure you will find it is an FPC/Laz Unit Definition issue.

Defining it as TEXT will display "(MEMO)" in all the data-aware db-fields other than a Memo. A bit useless.

The link in my previous post was to the SQLIte3 website and they say there is no limit for VARCHAR as it is treated as TEXT internally with unlimited length.

[LacaK]

Thanks for the reply, but I mentioned above that I had tried adding the length designation to VARCHAR and it made no difference. I tried VARCHAR(2000), VARCHAR(32000), VARCHAR(max_int) and still got 255. Pretty sure you will find it is an FPC/Laz Unit Definition issue.

I can not believe this, because there are tests against SQLite which works with VARCHAR fields with size > 255
So problem must be somewhere else. Can you again ZIP here your database and test program ...

Defining it as TEXT will display "(MEMO)" in all the data-aware db-fields other than a Memo. A bit useless.

Yes

The link in my previous post was to the SQLIte3 website and they say there is no limit for VARCHAR as it is treated as TEXT internally with unlimited length.

Yes, true