Home » RDBMS Server » Server Utilities » Problem with special character........
Problem with special character........ [message #253462] Tue, 24 July 2007 01:11 Go to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
Hi All,

I have extracted data from teradata with the help of one open source tool. Tool extracted special character as \351(in octal code) & my problem is, while inserting \351 in oracle it get stored as i in the place of .

How i can insert special character in oracle?

kindly help me in this.

Thanx
Din
Re: Problem with special character........ [message #253468 is a reply to message #253462] Tue, 24 July 2007 01:15 Go to previous messageGo to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
Sorry forgot to mention, i'm facing this problem with SQL LOADER.
Re: Problem with special character........ [message #253469 is a reply to message #253462] Tue, 24 July 2007 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to:
1/ use a database character set that is compatible (a super-set) with your original character set
2/ set your NLS_LANG with a character set that is compatible (a super-set) with your original character set

Regards
Michel
Re: Problem with special character........ [message #253470 is a reply to message #253468] Tue, 24 July 2007 01:19 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In SQL*Loader you also have the CHARACTERSET parameter to specify the character set of your data file.

Regards
Michel
Previous Topic: data import
Next Topic: problem with sqlldr
Goto Forum:
  


Current Time: Sat Dec 10 03:29:18 CST 2016

Total time taken to generate the page: 0.12067 seconds