Home » RDBMS Server » Server Utilities » SQLLoader Unicode from Unix enviroment (SQLLoader)
SQLLoader Unicode from Unix enviroment [message #354164] Thu, 16 October 2008 14:06 Go to next message
renjivij
Messages: 17
Registered: October 2008
Junior Member
Im trying to load the data file containing unicode characters(French) into nvarchar field in Oracle DB using
sqlloader and it works fine in Windows environment.

WHen im trying to load the same data file from a unix envirmonemnt the data gets entered as junk characters.

Could someone help me how i can load the data into nvarchar field in unix environment using sqlloader.

DB Oracle 10G
File encoding UTF-8

CTL File

load data
REPLACE INTO TABLE tabletest
fields terminated BY "|" optionally enclosed BY '"'
TRAILING NULLCOLS
(test ,
test1)

[Updated on: Thu, 16 October 2008 14:12]

Report message to a moderator

Re: SQLLoader Unicode from Unix enviroment [message #354199 is a reply to message #354164] Thu, 16 October 2008 23:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Check you NLS_LANG parameter
2/ Use CHARACTERSET parameter in control file

Regards
Michel
Re: SQLLoader Unicode from Unix enviroment [message #354312 is a reply to message #354199] Fri, 17 October 2008 10:45 Go to previous message
renjivij
Messages: 17
Registered: October 2008
Junior Member
Thanks.. it worked using character set in ctl file
load data
CHARACTERSET UTF8
Previous Topic: import .dmp file using IMP utility for tablespaces
Next Topic: AutoCommit after DBMS_DATAPUMP.open
Goto Forum:
  


Current Time: Sat Dec 03 10:05:30 CST 2016

Total time taken to generate the page: 0.22531 seconds