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