Ok. Its not a persistent field but I didn't rebuild all the packages.
Juts did that and it seems to be fixed.

Thanks
Rob

On 15/07/2013 6:18 p.m., IBO Support List wrote:
> You could have a persistent string field defined. Also, you have to rebuild
> all of your packages if you want a change to that line of code to be
> affective in the IDE.
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of Robert Martin
> Sent: Sunday, July 14, 2013 9:42 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] DB grid display of text fields (Showing as MEMoO)
>
> Hi Jason
>
> I have had a little more of a play with this and can confirm that changing
> the MaximumStringSize: Integer = 255 to something larger does NOT seem to
> fix the problem !
>
> Interestingly I have a DB Management tool where fields show as (MEMO) when
> defined as VarChar(70). However within the same application using the
> 'Browse' option of the 'IB_UtilityBar' and browsing to the same table works
> fine.
>
> Do you have any idea where I should go with this? I have just about
> finished sorting all the other issues with this upgrade and this is looking
> to be the big hold up soon.
>
>
> Thanks
> Rob
>
>
>
>
> On 9/07/2013 9:23 a.m., Robert Martin wrote:
>> Hi Jason
>>
>> Did you get a chance to test this?
>>
>> Thanks
>> Rob
>>
>> On 5/07/2013 10:46 a.m., Robert Martin wrote:
>>> Hi Jason
>>>
>>> Just checked it with another table defined as follows
>>>
>>> CREATE TABLE PHONE (
>>> ENTITYREF NUMERIC(11) NOT NULL,
>>> DAYPHONE VARCHAR(30) CHARACTER SET UTF8 COLLATE UTF8,
>>> AHPHONE VARCHAR(30) CHARACTER SET UTF8 COLLATE UTF8,
>>> FAXPHONE VARCHAR(30) CHARACTER SET UTF8 COLLATE UTF8,
>>> CELLPHONE VARCHAR(30) CHARACTER SET UTF8 COLLATE UTF8,
>>> EMAILADDR VARCHAR(70) CHARACTER SET UTF8 COLLATE UTF8,
>>> WEBSITE VARCHAR(50) CHARACTER SET UTF8 COLLATE UTF8
>>> );
>>> ALTER TABLE PHONE ADD CONSTRAINT PHONE_ENTITYREF
>>> PRIMARY KEY (ENTITYREF);
>>>
>>>
>>> When viewing the results in an IBTable or IBQuery (Select * from
>>> phone), the EmailAddr field shows as (memo). I am using IBO 5.2.0 6
>>>
>>> it should be pretty easy to whip up a test app at your end. If not I
>>> can make something for you.
>>>
>>> Thanks
>>> Rob On 5/07/2013 10:32 a.m., Robert Martin wrote:
>>>> 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
>>>>>
>>>> ------------------------------------
>>>>
>>>>
> ___________________________________________________________________________
>>>> 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
>>>
>>>
>>>
>>>
>>> -----
>>> 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
>>
>>
>>
>>
>> -----
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 2013.0.3349 / Virus Database: 3204/6474 - Release Date: 07/08/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.3349 / Virus Database: 3204/6493 - Release Date: 07/15/13
>
>