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

Report message to a moderator

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.

Report message to a moderator

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: 68664
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

Report message to a moderator

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: 68664
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 22 21:49:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.