MSSQL Varchar Fields beyond 255 characters

David Kenavan

Delphi Developer

Fri, 05 Oct 2001 03:00:00 GMT

MSSQL Varchar Fields beyond 255 characters

MSSQL Varchar Fields beyond 255 characters
In Delphi 3 with BDE5.1, MSS varchar fields > 255 characters do not appear
to work
correctly. The documentation for the latest BDE suggests that this is so as
well.
A varchar declcared in the db as varchar(1000) appears in the object
inspector as
having length 232, since the upper 16 bits of the 32 bit representation of
its length
is being removed.

We are using the Client Server version of Delphi 3 with the MSSQL native
driver. I
presume the same problem would be present if we were using the latest ODBC
driver.

Does anyone have any further info on this issue, particularly as to any
possible
work-around?
Thanks
Dan

Other Threads

1. Retriving MSSQL char fields larger than 255 characters with delphi

2. Varchar greater than 255 characters

3. problens with MSSQL 7.0 with varchar greater than 255

4. Varchar(255) vs Varchar(256) and TStrigField vs TMemoField

5. 255 Character Limit - D3/MSSQL 6.5

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

7. Problems with Varchar field larger than 255

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

9. VarChar fields > 255 chars

10. SQL Server 7 Varchar field greater than 255