Problems with UTF8
Date: Mon, 13 Oct 2008 23:52:07 +0200
We have our database created with nls_characterset=al32utf8. With special characters we are noticing some strange behaviour.
One of the teams internally insists we provide the flat files delimited by inverted exclamation (í). We couldnt get this working right.
The extracts either appear as ? or blanks.
OS is Solaris 10. Options tried
With this setting, the following works
select 'AíB' from dual;
But, select 'A'||'í'||'B' from dual; doesnt work. The inverted excl just appears blank.
We finally got this working using NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 and LANG=en_US.ISO8859-1
However, if someone has faced a similar problem we would like to know why the UTF8 settings dont work and just gives out blanks for th delimiter.