Problems loading data into the database using SQL Loader.

Database
Oracle 9.2.0.8

NLS_LANG=AMERICAN_AMERICA.UTF8
NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16

Server
Red Hat Linux 2.6.9-67.ELsmp
LANG=en_US.UTF-8

I cannot figure this one out. When I try to populate a table using SQl Loader I am getting corrupt characters in the table e.g. Alien³ appears in the table as Alien¿

I have even set the CHARACTERSET to UTF8 in the control file for good measure!

Can anyone throw some light on this one?

Thanks in advance for your replies.

TB3101 Received on Tue Jun 23 2009 - 11:42:03 CDT