Yeah that's what I would have though too !

I am porting a large DB from an unspecified character set DB to a new
UTF8 format DB at the moment, using IBPump. When its finished I will do
a bit more testing and make sure there really is a problem. I certainly
saw it yesterday with the varChar(75) field though. Although the
particular table is unusual as that field is also the primary key.

Will let you know my findings.

Thanks
Rob

On 5/07/2013 10:26 a.m., IBO Support List wrote:
> I'm a bit puzzled because it is supposed to hinge on CharLen and not ByteLen
> so this shouldn't even be an issue.
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of Robert Martin
> Sent: Thursday, July 4, 2013 4:20 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] DB grid display of text fields
>
> Awesome !
>
> Any recommendations, should I just multiply it by 4 and set it to 1020?
>
> Thanks
> Rob
>
>
> On 5/07/2013 10:16 a.m., IBO Support List wrote:
>> 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
>>
>>
>>
>>
>>
>> ------------------------------------
>>
>> ______________________________________________________________________
>> _____ 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
>>
>>
>>
>>
>> -----
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 2013.0.3345 / Virus Database: 3204/6465 - Release Date:
>> 07/04/13
>>
>>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.3345 / Virus Database: 3204/6465 - Release Date: 07/04/13
>
>