Hello. In some cases we create tables where column names contain non-ASCII symbols, for example:
CREATE TABLE f56ĆŻŻ (VŻ int, VĆ nchar(10))
But when I try to retrieve column names using OciAttrGet, I get "ASCII version" of the column name: VZ and VC.
OciAttGet call for any column is:
OciAttrGet(...,OCI_DTYPE_PARAM, (dvoid**) &col_name, (ub4 *) &nNameSize, OCI_ATTR_NAME, errh)
and nNameSize correctly(?) returns 4 (2 symbols in column name X 2 bytes per symbol).
But col_name has value "VZ" (wchar_t*), but not VŻ.
The environment is initialized using the following call:
OciEnvNlsCreate(. . ., OCI_UTF16ID, OCI_UTF16ID)
My impression - since I use UTF16ID value at initialization, all metadata should be in UCS2 format.
So how to get correct column names? Or I miss some options controlling encoding in OciAttrGet?
Thanks,
Alex