I have a Table on SQL Server having a VarChar(500) field. When I query this table using a TQuery component, it only returns the first 255 characters from the 500 char field.
I tried the same thing with TADOQuery object and it worked fine, all 500 char were returned.
I HAVE to use a TQuery object (I cannot switch to a TADOQuery).
Can anyone help me with this ?