Unicode table/column names

rmovchan · Post by **rmovchan** » Mon 24 Apr 2006 02:13

Does ODAC support Unicode in table/column names? Oracle's Raptor is a Java application and has no problems with Unicode whatsoever. You can create a table with arbitrary Unicode characters in the name, and then select from it. However, when I try to do the same in Delphi/ODAC (with UseUnicode=true), I get Oracle errors. The reason is I guess because the environment isn't initialized properly: OCI_UTF16 flag is missing in the call to OCIEnvCreate, therefore all other calls take only ANSI and not UTF-16 strings as parameters.

So, I would claim that Unicode support in ODAC is only partial. You can work with Unicode data in tables and pass Unicode strings as values of bind variables, but Unicode in SQL statements, such as table and column names, is not supported, even though it's permitted by Oracle. My question is, do you have plans to include the full Unicode support in the future? I know that your OraDirect library for C# already has it.

Thanks,
Roman

Challenger · Post by **Challenger** » Tue 25 Apr 2006 13:01

ODAC doesn't support unicode in table and column names. We plan to implement such functionality but not
in the near future.