Problems with UTF8

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

NLS_LANG=AMERICAN_AMERICA.AL32UTF8
LANG=en_US.UTF8

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.

Rgds,
Gokul

--
http://www.freelists.org/webpage/oracle-l