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