D2009 and DOA 4.1.2 and Unicode

[benthicsoftware]

Hi Marco,

I'm a bit confused on Unicode support in DOA 4.1.2. It looks like it always brings data as utf8 (if that's the databases character set) and then converts it to utf16 on the client. Is there a way to set the session to use utf16 by default? Usually this is done using OCI_UTF16 in the OCIEnvCreate call or using OCI_UTF16ID in OCIEnvNlsCreate. Am I correct that this would be the preferred method when using d2009?

I've been playing with the QueryGrid demo under d2009 and I can't seem to get the following query to return the unicode data properly (it seems to be converted to ansi at some point):

select 'αβγδεζηθ4' from dual;

Should this be possible? I've tried various DOA options and NLS_LANG settings. Thanks for any comments or suggestions!

-Mark

 

[Marco Kalter]

I'm a bit confused on Unicode support in DOA 4.1.2. It looks like it always brings data as utf8 (if that's the databases character set) and then converts it to utf16 on the client.

That is indeed correct.

I've been playing with the QueryGrid demo under d2009 and I can't seem to get the following query to return the unicode data properly (it seems to be converted to ansi at some point):

select 'αβγδεζηθ4' from dual;

Can you send me a little demo project that or code example that reproduces the problem?

 

[benthicsoftware]

Hi Marco,

As mentioned, the code in question is the QueryGrid demo from the DOA install. I see that the unicode characters in my query got converted in the html. It's just a test query of dual with a number of greek unicode characters in a string literal. I can query the same string from a table and have it show properly in the QueryGrid application, so it's something about having the unicode in the SQL string.

-Mark