Subject Re: [IBO] Data type char issues (for lack of a better subject)
Author Robert Martin
AWESOME !!!

When can I get my hands on build 8?

Cheers
Rob


On 27/08/2013 6:36 a.m., IBO Support List wrote:
> I took notice of this and I added the ability to have field compatibility
> with ftFixedWideChar.
>
> This will be included in Build 8.
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of Robert Martin
> Sent: Sunday, August 25, 2013 10:31 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Data type char issues (for lack of a better subject)
>
> Hi
>
> Further to my previous email I found some web links that talk about the same
> sort of issue with ADO, Don't know if this helps but the fix was along the
> lines of...
>
> compatible:= FieldDef.DataType in [ftstring,ftwidestring,ftfixedWideChar]
> Original :
> compatible:= FieldDef.DataType in [ftstring,ftwidestring]
>
> Cheers
> Rob
>
> On 26/08/2013 4:18 p.m., Robert Martin wrote:
>> Hi Jason
>>
>> Have been working on moving to Delphi XE2 (from 2007) and also to new
>> versions of IBO and now FB itself. We wanted to avoid changing the DB
>> version as well but unfortunately it seems that 2.0 had some UTF issues.
>>
>> Anyway mostly though the process and just popped our software on a FB
>> 2.5.2 virtual machine. Copied a backup of a DB across and restored so
>> that it would be 2.5.2 format. The DB is specified as UTF8. When I
>> open screens I get messages like ....
>>
>> Query: Type mismatch for field 'fieldname', expecting: String actual
>> FixedWideChar.
>>
>>
>> These fields are defined in the DB as Char(1). It appears they are
>> defined as persistent fields and that when connecting to a FB 2.5.2
>> they are now returning as a different type. It appears the following
>> is true
>>
>> a) Delphi 2007 - IBO 4.8.7 - FB 2.0 WORKS
>> b) Delphi 2007 - IBO 4.8.7 - FB 2.5.2 WORKS
>> c) Delphi XE2 - IBO 5.2.0.6 - FB 2.0 WORKS
>> d) Delphi XE2 - IBO 5.2.0.6 - FB 2.5.2 FAILS
>>
>> This is pretty major for us, what should I do?
>>
>> 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
>>
>>
>>
>>
>> -----
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 2013.0.3392 / Virus Database: 3211/6607 - Release Date:
>> 08/25/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.3392 / Virus Database: 3211/6607 - Release Date: 08/25/13
>
>