Hi

I Have found the issue. If I replace UpdateQuery below (a TIBOQuery)
with a TIB_Query the code works perfectly. We would prefer to use the
IBOQuery as we have subclassed it. I think I read something about a
problem with Unicode a while ago, has this been fixed yet? We are using
version 4.8.6

My apologies If I haven't replied to other peoples emails regarding my
previous posts. I don't seem to be receiving emails at the moment.


Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Robert martin wrote:

> Hi
>
> I have a component (TadvStringGrid) from Tms software that is Unicode
> capable. I have put some Arabic into it and try to save it my database
> using the following test code
>
> with zBookingsDM.UpdateQuery do begin
> SQl.Clear;
> SQL.Add('INSERT INTO Pi_Fel_Wording (PhraseRef, Other) Values
> (1, :Test)');
> Prepare;
>
> ParamByName('Test').AsWideString := AdvStringGrid1.WideCells[1,1];
> ExecSQL;
> end;
>
>
> When I try reading it back out using the following
>
> with zBookingsDM.UpdateQuery do begin
> SQl.Clear;
> SQL.Add('SELECT Other FROM Pi_Fel_Wording WHERE PhraseRef = 1');
> Prepare;
>
> Active := True;
> AdvStringGrid1.WideCells[2,2] := FieldByName('Other').AsWideString;
> Active := False;
> end;
>
> I get ???????? in the cell.
>
> The 'Other' field is defined as Other VarChar(254) CHARACTER SET
> UNICODE_FSS.
>
>
> Can anybody see what I am doing wrong?
>
>