Board index » delphi » SQL Server 7 Varchar fields > 255

Andre' Furstenrecht

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

SQL Server 7 Varchar fields > 255

My development environment is Delphi 3 and BDE 5.01 and SQL Server 7.0.
Since shifting from SQL Server 6.5 to 7.0 there are fields within some
tables of the database that are currently Text fields that may be able to be
converted to large varchars.
However a quick test of a varchar 3000 field in the server showed the TField
setting a size of 255 when field data was retrieved. Manually setting the
size to 3000 resulted in the field not been of the size expected.

Is this a short coming with Delphi itself. In which case given currently
using Delphi 3 does Delphi 4 or Delphi 5 allow varchar fields up to 8000 ?
Or is it (yet another) BDE short coming ?

Andr

 
Euan Garde

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Server 7 Varchar fields > 255


The BDE uses dblib to connect to SQL Server, this library was not  enhanced
to support the new features in SQL7 (large columns, guids etc etc).

To access this new functionality you should use OLE DB(ADO) or ODBC.

D5 comes with ADO support and there are many add ons that support ADO.

-Euan

Quote
Andre' Furstenrecht <usern...@arcom.com.au> wrote in message

news:7qktms$dqq17@forums.borland.com...
Quote
> My development environment is Delphi 3 and BDE 5.01 and SQL Server 7.0.
> Since shifting from SQL Server 6.5 to 7.0 there are fields within some
> tables of the database that are currently Text fields that may be able to
be
> converted to large varchars.
> However a quick test of a varchar 3000 field in the server showed the
TField
> setting a size of 255 when field data was retrieved. Manually setting the
> size to 3000 resulted in the field not been of the size expected.

> Is this a short coming with Delphi itself. In which case given currently
> using Delphi 3 does Delphi 4 or Delphi 5 allow varchar fields up to 8000 ?
> Or is it (yet another) BDE short coming ?

> Andr

Toan

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Server 7 Varchar fields > 255


Convert it to "Text" and it will work OK. Delphi can handle large text field
from MS/SQL 7.

Toan

Quote
Andre' Furstenrecht <usern...@arcom.com.au> wrote in message

news:7qktms$dqq17@forums.borland.com...
Quote
> My development environment is Delphi 3 and BDE 5.01 and SQL Server 7.0.
> Since shifting from SQL Server 6.5 to 7.0 there are fields within some
> tables of the database that are currently Text fields that may be able to
be
> converted to large varchars.
> However a quick test of a varchar 3000 field in the server showed the
TField
> setting a size of 255 when field data was retrieved. Manually setting the
> size to 3000 resulted in the field not been of the size expected.

> Is this a short coming with Delphi itself. In which case given currently
> using Delphi 3 does Delphi 4 or Delphi 5 allow varchar fields up to 8000 ?
> Or is it (yet another) BDE short coming ?

> Andr

Other Threads

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

2. SQL Server 7 Varchar field greater than 255

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

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

5. VarChar fields > 255 chars

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

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

8. SQL Server 7 string field lengths >255 length

9. varchar>255 and collate DE_DE

10. VARCHAR > 255 avec