Subject | DB grid display of text fields |
---|---|
Author | Robert Martin |
Post date | 2013-07-04T22:02:51Z |
Hi
We have always known that TDBGrid displays text fields > 254 characters
as (MEMO) rather than displaying the text. However we have just moved
from D2007 to XE2, IBO 4.8 to 5.2 and changed the DB format from
unspecified to UTF8. Now fields defined as less than 254 characters are
showing as (MEMO). For example one defined as 'only' VarChar(75) shows
as (MEMO). I assume that Delphi is using SizeOf for this test rather
than Length().
I vaguely remember that there was a setting somewhere that could be used
to change when the (MEMO) is displayed. Does anyone know where?
Thanks
Rob
We have always known that TDBGrid displays text fields > 254 characters
as (MEMO) rather than displaying the text. However we have just moved
from D2007 to XE2, IBO 4.8 to 5.2 and changed the DB format from
unspecified to UTF8. Now fields defined as less than 254 characters are
showing as (MEMO). For example one defined as 'only' VarChar(75) shows
as (MEMO). I assume that Delphi is using SizeOf for this test rather
than Length().
I vaguely remember that there was a setting somewhere that could be used
to change when the (MEMO) is displayed. Does anyone know where?
Thanks
Rob