Home » RDBMS Server » Server Utilities » Insert diacritic marks
Insert diacritic marks [message #198664] Wed, 18 October 2006 03:05 Go to next message
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?
Re: Insert diacritic marks [message #198694 is a reply to message #198664] Wed, 18 October 2006 04:46 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may want to check this thread Special Characters.
Re: Insert diacritic marks [message #198825 is a reply to message #198664] Wed, 18 October 2006 12:57 Go to previous messageGo to next message
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
Re: Insert diacritic marks [message #198839 is a reply to message #198825] Wed, 18 October 2006 16:05 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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
Re: Insert diacritic marks [message #198844 is a reply to message #198839] Wed, 18 October 2006 17:01 Go to previous message
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:
  


Current Time: Sun Dec 11 00:11:30 CST 2016

Total time taken to generate the page: 0.09329 seconds