Hi,
I have some further information on my problem. The insertion of UTF-8 data into
nchar seems to work like it does for nvarchar2; it appears it is the selecting
from nchar fields that is not returning the data inserted. I have verified this
by inserting the same data into nchar and nvarchar
I seem to have identified the difference between selecting from nchar and
nvarchar columns containing unicode data:
for nvarchar:
col 1: dbtype 1, scale 0, prec 512, nullok 1, name A
: dbsize 512, char_used 1, char_size 256, csid 2000, csform 2, disize 512
for ncahr:
col 1: dbtype 96, scale
Hi,
Wondered if anyone can tell me if I've misunderstood something here. I am able
to insert unicode data into nvarchar2 and get back what was inserted but same
code with nchar column does not work.
OCI version is 10.1.0.2
Database is Oracle 10.2 on Linux
Database CHAR set is WE8ISO8859P1