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

Gela Pavliashvili

Delphi Developer

Tue, 09 Apr 2002 03:00:00 GMT

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

I use Delphi4 and IB5.

if field is Varchar(255) it appears in the DataSet as TStringField,
if field is Varchar(256) or large it appears in the DataSet as TMemoField
and in the Grid view as (MEMO),
Can I make Varchar(500) field view in the Grid?

Thanks,

Gela Pavliashvili
gela...@usa.net

Dan Palle

Delphi Developer

Tue, 09 Apr 2002 03:00:00 GMT

Re:Varchar(255) vs Varchar(256) and TStrigField vs TMemoField

You'll need to use a grid replacement component that lets you view memos in
a grid. Or, you can trim the size of the result field to 255 chars using a
UDF.

This is really a DBGrid/TField issue and not an IBX issue.

Dan

Quote

Gela Pavliashvili <g...@parliament.ge> wrote in message

news:7up3a7$g4l12@forums.borland.com...

Quote

> I use Delphi4 and IB5.

> if field is Varchar(255) it appears in the DataSet as TStringField,
> if field is Varchar(256) or large it appears in the DataSet as TMemoField
> and in the Grid view as (MEMO),
> Can I make Varchar(500) field view in the Grid?

> Thanks,

> Gela Pavliashvili
> gela...@usa.net

Other Threads

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

2. Problems with Varchar field larger than 255

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

4. Varchar grater then 255 in SQL 7

5. VARCHARs longer than 255 problem

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

7. varchar>255 and collate DE_DE

8. problens w/ varchar greater than 255

9. problens with MSSQL 7.0 with varchar greater than 255

10. Sybase 11.9.2 varchar over 255