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