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
>
>