RE: Oracle ncahr versus nvarchar2 and unicode data

2005-07-19 Thread Martin J. Evans
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

RE: Oracle ncahr versus nvarchar2 and unicode data

2005-07-19 Thread Martin J. Evans
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

Oracle ncahr versus nvarchar2 and unicode data

2005-07-18 Thread Martin J. Evans
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