I do not have a unicode database. I should be able to read and write greek to oracle using nvarchar or nclobs. I got this to work with Oracle's SQL Developer by adding this one line to:
sqldeveloper\sqldeveloper\bin directory, open the file sqldeveloper.conf and add another AddVMOption line below other such lines:
AddVMOption -Doracle.jdbc.convertNcharLiterals=true
I should be able to do this with a simple DAO program. I have a ticket with oracle support open on this, but I was wondering if any java developers here can give me a hand? I am actually a DBA.
Has anyone gotten this to work?