OraFAQ Forum: Server Utilities » Problem with special character........

Home » RDBMS Server » Server Utilities » Problem with special character........

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with special character........ [message #253462]

Tue, 24 July 2007 01:11

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

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

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 13 07:05:06 CDT 2026