Devart Forums

Hi

I use Delphi 2009,ODAC 6.80.0.47 and Oracle 9.0.1.1.1

Oracle Server Character Set : UTF8

TOrasesion.Option.Direct := True;
TOrasesion.Option.Charset := '';
TOrasesion.Option.Unicode := True;


I use the TSmartQuery component to query Unicode SQL

SQL)
Select * from all_object where object_name = '작업테이블'
=> Query success

but error does occur if use parameter

Sample Code:

procedure TForm11.FormCreate(Sender: TObject);
begin
OCIUnicode := True;
OraSession1.Connect;
end;

QTemp.SQL.Text := 'Select * from all_object where object_name = :obj';
QTemp.ParamByName('obj').DataType := ftString;
QTemp.ParamByName('obj').Value := '작업테이블';
QTemp.Open;

or
QTemp.SQL.Text := 'Select * from all_object where object_name = :obj';
QTemp.ParamByName('obj').DataType := ftString;
QTemp.ParamByName('obj').asString := '작업테이블';
QTemp.Open;

or
QTemp.SQL.Text := 'Select * from all_object where object_name = :obj';
QTemp.ParamByName('obj').DataType := ftWideString;
QTemp.ParamByName('obj'). Value := '작업테이블';
QTemp.Open;

error mesage is
ORA-01460: unimplemented or unreasonable conversion requested

--------------------------------------------------------------------------
same error does occur even if TOraSession.Options.CharSet = UTF8

Error does not occur if Oracle Server Character Set is AL32UTF8 or KO16MSWIN949 .

Error does not occur if TOraSession.Options.Direct=False

Thanks for any helep

We could not reproduce the problem. Please send to odac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

The email send to you
Thanks!

Sample program attached to e-mail and i have not received a reply
Did you get email?

We have received your e-mail and we will look into it.

Same problem. Any update?

To Ken:

Please describe the steps to reproduce the problem.

Dear Plash,

We hit the same problem as ysyang in ODAC 6.8.0.50. In June you said that you're going to have a look at it. Any news?

Thanks,
Alexander

We have tested the problem using the sample project. But we could not reproduce the problem.

Sent you an e-mail
Created: Tue, 15 Sep 2009 19:34:07 +0200
Subject: Sample code for #14385 and #15010
Attachments: TestODAC.rar