Hmmm.... You should be getting TFixedWideChar at the least...

Perhaps I should take a closer look?

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Robert Martin
Sent: Wednesday, September 11, 2013 4:12 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] More (perhaps) UTF8 issues

Hi

That's what I initially thought but Its actually the reverse this time.
The field IS defined as TWideStringField but the DB seems to be
returning TFixedChar, which IBO is disallowing.

Thanks
Rob

On 12/09/2013 10:06 a.m., IBO Support List wrote:
> Hi Rob,
>
> IBO is disallowing you to have a persistent field that is incapable of
> displaying unicode data.
>
> You need to do a search and replace in your app like we did before and
> replace TFixedCharField (or whatever it is called) and put
TWideStringField
> in its place.
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
Behalf
> Of Robert Martin
> Sent: Wednesday, September 11, 2013 3:59 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] More (perhaps) UTF8 issues
>
> Hi Jason
>
> Not sure if this was one of the things we worked through or not but I
> have just run into the following persistent field definition issue.
>
> Database : FB 2.5.2
> Defualt DB Character set : UTF8
> Error : Query : Type mismatch for field 'Completed', expecting:
> WideString actual: FixedChar
>
> The Query field is defined as TWideStringField
>
> The SQL for the query is the following
>
> SELECT GlTransRef, TransDate, Ref, Detail, ExportStatus , Completed
> FROM vwALLGLTrans
> WHERE ExportStatus IS NULL
>
>
> vwALLGLTrans is a view that is defined as follows...
>
> CREATE VIEW vwAllGLTrans (GLTransRef, TransDate, Ref, Detail,
> SEntityRef, BatchDate, BatchTime, PeriodNum, MEntityRef, PostedFrom,
> BEntityRef, ImportRef, ExportStatus, Completed) AS
> SELECT GLTransRef, TransDate, Ref, Detail, SEntityRef, BatchDate,
> BatchTime, PeriodNum, MEntityRef, PostedFrom, BEntityRef, ImportRef,
> ExportStatus, 'F'
> FROM GLTrans
> UNION ALL
> SELECT GLTransRef, TransDate, Ref, Detail, SEntityRef, BatchDate,
> BatchTime, PeriodNum, MEntityRef, PostedFrom, BEntityRef, ImportRef,
> ExportStatus, 'T'
> FROM GLCompletedTrans^
>
>
> It appears that FB is ignoring the database default characterset (UTF8)
> for the Completed field and is returning it as a fixed ansi char instead
> of a fixed UTF8 char (TFixedWideChar).
>
> I'm not sure if this is a FB fault or not.
>
> Any ideas how to get around it?
>
> 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 !
> http://tracker.ibobjects.com - your portal to submit and monitor bug
reports
> http://community.ibobjects.com - your portal to purchase and upgradeYahoo!
> 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 !
> http://tracker.ibobjects.com - your portal to submit and monitor bug
reports
> http://community.ibobjects.com - your portal to purchase and upgradeYahoo!
Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.3392 / Virus Database: 3222/6656 - Release Date: 09/11/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 !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgradeYahoo!
Groups Links