Problems loading data into the database using SQL Loader.
Date: Tue, 23 Jun 2009 09:42:03 -0700 (PDT)
NLS_LANG=AMERICAN_AMERICA.UTF8 NLS_CHARACTERSET UTF8 NLS_NCHAR_CHARACTERSET AL16UTF16
Red Hat Linux 2.6.9-67.ELsmp
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