Devart Forums

If field value more than 8193 characters (Text field), when you use MYSQL built in function (Concat, Hex...) , result will be return up to 8193 characters only.

example:
Select TextField From TestData;

Select Concat(TextField, '--END--') From TestData;

Please fix it can return more than 8193 charaters when use MySQL built in function.

We reproduced your problem, this is MySQL server limitation. MyDAC can't change this behavior.

I already used MySQL Command Line Client and MySQl Query Browser to testing return result, two programs can be return more than 8193 chracters.

I think is client problem, not server.

mysql cmd line gives correct result. Problem is when you open a query with a text field using concat, it sets size of field to 8192, while other text fields size is 0. Even when you set it to 0, when opening query it goes back to 8192. As chintatlim states, i would say it's some problem with compos or delphi db.

Also under this query:

select *,concat(texto, '--END--') as texto2 from test_table

texto is a TMemoField and texto2 is a TStringField.

Remark: I just looked at db.pas from delphi7 , and there is this:
So problem is delphi.

MySQL Server describes this field as a string field rather than a text field.
You can avoid this problem by setting Options.LongStrings to False.