| Umlauts with SQL ldr [message #71542] |
Thu, 21 November 2002 07:42  |
Darshankar P
Messages: 1
Registered: November 2002
|
Junior Member |
|
|
Hi,
I am using sqlldr for loading into the database from csv file.
I have exported the following before using the sqlldr
export NLS_LANG=German_Germany.WE8ISO8859P1
Still I am not getting the umlauts in the databse.
Kindly help.
Thanks in advance.
|
|
|
|
| Re: Umlauts with SQL ldr [message #71555 is a reply to message #71542] |
Fri, 22 November 2002 05:39  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
Works fine for me ..
LOAD DATA CHARACTERSET WE8ISO8859P1
INFILE *
APPEND INTO TABLE GERMAN
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
( WORD )
BEGINDATA
uber
über
SQL> select * from GERMAN;
WORD
--------------------
uber
über
U want to translate some words ????
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
