Hi Jason

The code I am using is ....

To write to the DB

with InsertIBOQuery do begin
ParamByName('ID').AsInteger := NextId;
ParamByName('Text').AsWideString := TextEdit.Text;

ExecSQL;
end;

To read from the DB

ShowMessage(UTF8Decode(ViewIBOQuery.FieldByName('Text').AsString));


the following does not correctly return a value,

ShowMessage(ViewIBOQuery.FieldByName('Text').AsString);

The TDBgrid hooked up does not correctly display either.

I believe the version of IBO5 (v5.0.2 52) I am using is quite old. It
might be that this is fixed in newer releases.

Thanks
Rob

On 2/05/2013 4:10 p.m., IBO Support List wrote:
> Please show me the code. These should be called internally.
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of Robert Martin
> Sent: Wednesday, May 1, 2013 10:05 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Unicode help
>
> 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
>