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