UTF8 question [message #71439] |
Fri, 01 November 2002 12:26 |
Sankar B. Mandalika
Messages: 20 Registered: November 2002
|
Junior Member |
|
|
Hi All,
Here is a UTF8 related problem that we are running into:
The problem is occurring while trying to load a '|' delimited flat file data (has UTF8 data) into Oracle database (8.1.7.2 server) using SQL Loader. SQL Loader is not loading the data properly when it comes to special characters like umlauts (Ü or Ö ), we have a lot of German data in the file. I would like to know how to tell SQL Loader that the file had UTF8 data. Currently, we only set NLS_LANGUAGE env variable to AMERICAN_AMERICA.UTF8 and expect everything to be taken care of. Also our DB character set is UTF8.
This is running on Solaris 2.8.
Any suggestions/ideas would be greatly appreciated.
Thanks,
Sankar.
|
|
|
|