Hi

Since emailing I have discovered that if I use UTF8Encode() and
UTF8Decode() when writing to the database things work (with the DB field
defined as UTF8).

I will now investigate FB -> D2007 -> XML !

Cheers
Rob

On 2/05/2013 11:06 a.m., Robert Martin wrote:
> Hi
>
> I have an older version of IBO 5 (5.0.2 52) installed in Delphi Xe2
> which were are not really using. However we will shortly need to build a
> very basic app allowing entry and display of Unicode text. Primarily I
> want to add Chinese (simplified and traditional) as well as Thai.
>
> I am attempting to enter some test text. This displays ok in my entry
> field but once inserted into the database the chinese charaters showed
> either as ???? (where the DB character set was none) or as funny ascii
> characters (採用新) where the db field was defined at UTF8.
>
> In my test app I am using an IBOQuery to insert with the following...
>
> sql:
>
> INSERT INTO aaa (id, Text)
> VALUES (:id, :text)
>
> Code:
> with InsertIBOQuery do begin
> ParamByName('ID').AsInteger := NextId;
> ParamByName('Text').AsWideString := TextEdit.Text;
> ExecSQL;
> end;
>
>
> I am viewing the results in a TDBGrid from the following SQL
>
> SELECT *
> FROM aaa
> ORDER BY id DESC
>
>
> Am I doing something wrong here ?
>
>
>
> My aim is to have a Delphi XE2 app developed to allow entry of non
> english language details. However a D2007 developed, IBO4 based app
> sends this data (via XML) to another system (web site). If I get my EX2
> app working, will I be able to use IBO4 to access it correctly and
> export 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 ! Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.3272 / Virus Database: 3162/6289 - Release Date: 05/01/13
>
>