| How to load UTF16LE Data into ISO8859P1 Database [message #73272] |
Sun, 14 March 2004 22:57  |
powi
Messages: 5
Registered: January 2004
|
Junior Member |
|
|
Can anyone tell how I can load UTF16LE Data into a ISO8859P1 Database with sqlloader.
I have alread tried it with "NLS_LANG" settings in the shell and "characterset UTF16"
"LOAD DATA
CHARACTERSET UTF16
INFILE 'utf_data.txt'
INTO TABLE table when f_6="0"
TRAILING NULLCOLS
( f_1,
f_2,
f_3,
f_4,
f_5,
f_6,
f_7 date "RRRRMMDD" NULLIF f_7="0"
)
"
Additionally the load limitations are making problems.
Is it possible to load utf16 data into a iso database??
|
|
|
|
| Re: How to load UTF16LE Data into ISO8859P1 Database [message #73274 is a reply to message #73272] |
Mon, 15 March 2004 03:44  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
I haven't tried it myself, but it should be possible. What is loaded into the DB? If nothing, you can try to code the WHEN clause as [[when f_6="0x0000"]].
For more info on this subject, see "Handling Different Character Encoding Schemes" in the "Oracle9i Database Utilities" guide - Chapter 5: "SQL*Loader Control File Reference".
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
