| Error in loading chinese characters [message #416192] |
Fri, 31 July 2009 01:51  |
sanjay6713
Messages: 40
Registered: June 2009
Location: INDIA
|
Member |
|
|
Hi All,
I try to import a sample chinese characters into my Oracle 10g Database through sql loader but throws an error saying "Field in data file exceeds maximum length".
My database char set is AL32UTF8 and i had set the
NLS_LANG=American_America.AL32UTF8.
I dont see any pit falls in my config.
Below is my table structure.
SQL> desc china2
Name Type
NUM NVARCHAR2(100)
NAME NVARCHAR2(1200)
Attached is the control file i used.
Thanks in Adv.
Sanjay
-
Attachment: control.ctl
(Size: 0.15KB, Downloaded 1579 times)
[Updated on: Fri, 31 July 2009 01:54] Report message to a moderator |
|
|
|
|
|
| Re: Error in loading chinese characters [message #417330 is a reply to message #416196] |
Fri, 07 August 2009 05:23  |
sanjay6713
Messages: 40
Registered: June 2009
Location: INDIA
|
Member |
|
|
Hello Michael,
thank you for immediate reply, sorry i waz not feeling gud these days and could not reply back immediately.
Wel, i try to insert a single chinese character but was unable to do as it was not loading into the database through SQLLDR.
How can we further go ahead.plz assist,,,
thank you in adv.
Sanjay
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Error in loading chinese characters [message #417926 is a reply to message #417889] |
Wed, 12 August 2009 02:25 |
sanjay6713
Messages: 40
Registered: June 2009
Location: INDIA
|
Member |
|
|
I tried executing a unicode text file in which chinese characters where present.
i got the below status from the log file.
SQL*Loader: Release 10.2.0.1.0 - Production on Wed Aug 12 12:46:37 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Control File: control.ctl
Character Set UTF8 specified for all input.
Data File: unicode.txt
Bad File: unicode.bad
Discard File: none specified
(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 CHINA2, 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
------------------------------ ---------- ----- ---- ---- ---------------------
NUM FIRST * , O(") CHARACTER
NAME NEXT * , O(") CHARACTER
Table CHINA2:
4 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: 33024 bytes(64 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 4
Total logical records rejected: 0
Total logical records discarded: 0
Run began on Wed Aug 12 12:46:37 2009
Run ended on Wed Aug 12 12:46:40 2009
Elapsed time was: 00:00:03.24
CPU time was: 00:00:00.01
But i dint see the correct chinese letters in the database which is displaying something like these below.
��" 1 0 0
" " 2�" " "
" 2 0 0
" " �" " "
" 3 0 0
" " o`" " "
Wel I understand unicode text file as the UTF datafile.
Please correct me on this.
Thanks,
Sanjay
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
