Using SQL Loader to load Russian data in Database configured with AL32UTF8
Hi,
I have this small problem. I have a database configured in AL32UTF8. When I am inserting data in russian from sqlplus.exe from command promt it inserts and when i try to load data with sqlldr it loads junk characters. Following are the details of the same:
DB configured in AL32UTF8Ansi Code Page in registry: 1252
Output of chcp:
C:\russ>chcp
Active code page: 437
NLS_LANG in registry: AMERICAN_AMERICA.WE8MSWIN1252
my controlfile:
LOAD DATA
INFILE 'C:\russ\russian.txt'
BADFILE 'C:\russ\russian.bad'
DISCARDFILE 'C:\russ\russian.dsc'
INTO TABLE "TEST"
INSERT
TRAILING NULLCOLS
(NAME
)
my table desc:
SQL> desc test
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME NVARCHAR2(100)
SQL>
My logfile:
SQL*Loader: Release 9.2.0.1.0 - Production on Ñðä Ìàð 29 16:24:34 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control File: C:\russ\russian.ctl
Character Set US8PC437 specified for all input.
Data File: C:\russ\russian.txt
Bad File: C:\russ\russian.bad
Discard File: C:\russ\russian.dsc
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table "TEST", loaded from every logical record.
Insert option in effect for this table: INSERT
TRAILING NULLCOLS option in effect
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
NAME FIRST 1 CHARACTER
Table "TEST":
6 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 256 bytes(64 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 6
Total logical records rejected: 0
Total logical records discarded: 0
Run began on Ñðä Ìàð 29 16:24:34 2006
Run ended on Ñðä Ìàð 29 16:24:35 2006
Elapsed time was: 00:00:00.31
CPU time was: 00:00:00.03
Can some one please tell me where am i going wrong?
Thanking in advance,
Regards,
Jay Munshi
http://jaydba.tripod.com