Hi Marco,

I want to run the following query:
select nchr(1513) from dual;
under Oracle 9i and get back a unicode character (it's a hebrew character that looks like a styleized 'W' that I'm using for testing.) I can't seem to get this back using DOA (I'm using some Unicode aware controls and have been able to just display the character without using DOA.) I have been able to get the above query to work using a web page and ASPDotNet (with the Oracle .Net data provider.) Any thoughts on this? My nchar characterset is set for UTF-16 and I'm doing this on Windows XP. I've tried setting BytesPerChar to autodetect as well as other values with no changes. The normal (non nchar) dataset I'm using is a single byte charset.

Thanks,

Mark Ford
Benthic Software


[This message has been edited by benthicsoftware (edited 21 April 2003).]