We plan to use OraDirect in the Unicode-mode for the next version of our software. Now I'm checking what we have to modify in the DB-instance and in our code to fully support unicode.
I've read that OraDirect uses UTF-16 when we set Unicode=true in the connect string.
When I create a new database instance, I can configure Oracle only to use AL32UTF8 as Database Character Set. There doesn't seem to exist a way to configure it to use UTF16.
So, is there a problem if OraDirect uses UTF-16 and Oracle uses UTF-8?
Thank you very much for your help!
Best regards,
Tom
Unicode - UTF-16 or UTF-8?
There is no way to define UTF-16 charset for database using Oracle client wizards. In .NET application you will get conversion from UTF-16 to UTF8 or any national charset.
You can avoid string conversion if you use UTF-16 charset for NCHAR, NVARCHAR fields.
Unicode mode in OraDirect .NET turns on ability of Oracle client to send SQL texts and parameter values in UTF-16 charset. Oracle converts these UTF-16 values to UTF8 for UTF8 database.
You can avoid string conversion if you use UTF-16 charset for NCHAR, NVARCHAR fields.
Unicode mode in OraDirect .NET turns on ability of Oracle client to send SQL texts and parameter values in UTF-16 charset. Oracle converts these UTF-16 values to UTF8 for UTF8 database.