why is oracle/jdbc oci driver converting double bytes to single bytes when storing
Specs:
Oracle 8.1.7
JDK 1.2
JDBC 2.0
Oracle JDBC OCI driver
Java Virtual Machine file.encoding property is set to UTF8
I'm running into a problem with insert Unicode characters into Oracle via the JDBC driver. My NLS_CHARACTERSET is set to UTF8 (both in the server and the client).
The column in which i m inserting the data is VARCHAR type.
I used SELECT DUMP(column) from table to see if the row is in UTF8 encoding. And it is showing it properly.
But when I insert data through my Java servlet - the unicode data is: "\u015f" + "\u0131" + "\u011f"
But when I get the dump as above it displays:
DUMP(WORD,16)
-------------------------
Typ=1 Len=4: 61,5f,31,1f
Which is specifically removing the 01 from the 015f, 0131 , 011f.
Looks like it is storing the double bytes as single bytes.
What is the problem ?? Can someone please help.
Neesha