| SQLLoader Unicode from Unix enviroment [message #354164] |
Thu, 16 October 2008 14:06  |
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
