See IB_Session.pas:

{: This global variable sets the limit for a VarChar to be
returned as a ftString FieldType, before it becomes a ftMemo FieldType
in TIBODataSet.}
MaximumStringSize: Integer = 255;

Jason


-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Robert Martin
Sent: Thursday, July 4, 2013 4:03 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] DB grid display of text fields

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



------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links