OraFAQ Forum: Server Utilities » Insert diacritic marks

Home » RDBMS Server » Server Utilities » Insert diacritic marks

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

Insert diacritic marks [message #198664]

Wed, 18 October 2006 03:05

bibber
Messages: 38
Registered: August 2006

Member

Hi,

I was inserting a texfile into an oracle table using sql loader and found out that diacritic marks (eg. ��) weren't inserted. Also via a regular "insert into" statements, the diacritic marks were converted into e, o, a....

Can this be solved by adjusting the sql loader control file or is it a database setting, which has to be changed?

Report message to a moderator

Re: Insert diacritic marks [message #198694 is a reply to message #198664]

Wed, 18 October 2006 04:46

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You may want to check this thread Special Characters.

Report message to a moderator

Re: Insert diacritic marks [message #198825 is a reply to message #198664]

Wed, 18 October 2006 12:57

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

SQL> create table sp_char ( name varchar2(20));

Table created.

SQL> insert into sp_char values ( '��)');

1 row created.

SQL> select * from sp_char;

NAME
--------------------
��)

ur facing problem in regular insert into statments thanx

Report message to a moderator

Re: Insert diacritic marks [message #198839 is a reply to message #198825]

Wed, 18 October 2006 16:05

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Actually, ebrian, this is the link you wanted to post (now I'm a mind reader) Wink

Report message to a moderator

Re: Insert diacritic marks [message #198844 is a reply to message #198839]

Wed, 18 October 2006 17:01

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You are right littlefoot. I actually meant to post both of those links.

The one I included specifically discussed special characters with SQL*Loader and I thought it would provide the OP additional insight into the other link.

Thanks for catching that.

BTW andrew, nice explanation on the special characters.

[Updated on: Wed, 18 October 2006 17:04]

Report message to a moderator

Previous Topic:	SPECIAL CHARACTERS
Next Topic:	running sql loader from unix shell script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 23:48:51 CST 2024