Inserting Welsh characters in 10g
572055Jun 5 2009 — edited Jun 5 2009Hello All,
NLS_CHARACTERSET=AL32UTF8
NLS_DATE_LANGUAGE=AMERICAN
NLS_NCHAR_CHARACTERSET=AL16UTF16
NLS_RDBMS_VERSION=10.2.0.4.0
I have inserted 'ÂÁÀÄÊÉÈËÎÍÌÏÔÓÒÖÛÚÙÜŴẂ' values using SQL developer. When querying this values from Toad or SQL plus "ŴẂ" is replaced with "??". We have a java function which reads this value and outputs to a web page. Output from java code displays "??".
I tried from Toad and SQL plus, it returns ?
select asciistr('Ẃ') from dual;
select unistr('\1E82') from dual;
The unicode value for Ŵ is 0372. I am not sure on how to use this unicode value to display Ŵ.
Thanks
Rashida