Problems with UTF8

From: gokulkumar gopal <>
Date: Mon, 13 Oct 2008 23:52:07 +0200
Message-ID: <>

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 'AB' 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.


Received on Mon Oct 13 2008 - 16:52:07 CDT

Original text of this message