255 chars in MSSQL 7.0.

Una

Delphi Developer

Sat, 03 Apr 2004 21:45:51 GMT

Problem with VARCHAR > 255 chars in MSSQL 7.0.

I am connected to MSSQL using the BDE native driver.
My problem is: I have a description field that is stored in the database as
VARCHAR(512)
Setting is not a problem but when i try and go to get the characters
from the database the whole string is truncated to 255 chars. i have tried
getting them AsString, Text and As Memo but they all truancate the string.
Any help with this problem would be greatly appreciated,
Una.

Other Threads

1. problens with MSSQL 7.0 with varchar greater than 255

2. VarChar fields > 255 chars

3. Problem reading memo or VarChar>255 with SQL Server

4. VarChar(>255) in SQL Srvr 7 problem

5. Interbase VARCHAR 255 chars in Delphi 4

6. MSSQL Varchar Fields beyond 255 characters

7. Cannot retrieve MS-SQLServer VARCHAR(n>255) or TEXT field in Delphi program

8. Cannot retrieve the data from a MS-SQLServer VARCHAR(n>255) or TEXT field

9. varchar>255 and collate DE_DE

10. VarChar(>255) in SQL Srvr 7 REVISED