SELECT get wrong result

[Eurocg]

Hello

I have an oracle 9 database with a varchar field. The value in the field is an UNC path: \Europa\APP\WIN.APP\demo\Updates

The value was saved by an Delphi ADO application. A select with this ADO application get the correct value. But if i select with UNIDAC the result is: ????????????????????s\

Code: Select all

var
  DS : TCustomUniDataSet;
  uniConnect : TUniConnection;
begin
  DS:= uniConnect.CreateDataSet as TCustomUniDataSet;
  DS.Options.EnableBCD := True;
  DS.Options.EnableFMTBCD := True;

  DS.SQL.Text := 'SELECT path FROM t_demo WHERE ...'
  DS.Prepare;

  DS.Execute;

  Edit1.Text := DS.FieldByName('path').AsString;
end;

The same select with MS SQL Server as database engine get always the correct value, so i think it´s an oracle unidac problem???

Can you help me.
Christian

[Eurocg]

It looks nearly like a unicode problem. But the value has no unicode char. If i change the value to : C:\demo\Updates all looks fine.

Also this problem is only by a customer pc. My Oracle does not give ??? back.

Unfortunately I do not know why.