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.
Result Return Up To 8193 Characters Only When use MySQL Built In Function
-
- Posts: 22
- Joined: Tue 09 Nov 2004 00:31
-
- Posts: 22
- Joined: Tue 09 Nov 2004 00:31
Why MySQL Command Line Client and MySQl Query Browser Can Return More Than 8193 Characters?
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.
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.
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:
Code: Select all
dsMaxStringSize = 8192; { Maximum string field size }