unicode char problem in sql in 9.2.7

[angmar]

When I use turkish chars in SQL string, I can not see thees chars correct.
For example, "select 'öçşiğü' from dual" query result seems wrong. I see something like this "?????" word with question marks.
Unfortunately, this error started after I upgraded odac to 9.2.7
What is the solution for this version of ODAC ?

[AlexP]

Hello,

For correct display of unicode symbols, you should enable the following options: UseUnicode and UnicodeEnvironment

Code: Select all

  OraSession1.Options.UseUnicode := True;
  OraSession1.Options.UnicodeEnvironment := true;

  OraQuery1.SQL.Text := 'Select ''öçşiğü'' from dual';
  OraQuery1.Open;

[angmar]

OraSession1.Options.UnicodeEnvironment := true; gives chinese errors.

[AlexP]

Please provide the code of the error appearing on connection to the server when the UnicodeEnvironment option is enabled

[lrauti]

I am using the latest ODAC 9.2.7 with XE5 (with Oracle 11g) and I also get an error message with chinese characters.

Set the following options to TOraSession component:

Options.Direct := True
Options.UnicodeEnvironment := True
Options.UseUnicode := True
Schema := 'system'
Username := 'system'
Server := 'localhost:1521:SID=example'
Password := <password>
LoginPrompt := False

Now set Connected := True and there will be a nasty error...

[AlexP]

We have already fixed this proble. The new version with this fix is already available for download at our website.