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