Home » Other » General » Unicode prob with arabic data in oracle
Unicode prob with arabic data in oracle [message #125615] Tue, 28 June 2005 01:25 Go to next message
Messages: 2
Registered: June 2005
Location: hyderabad
Junior Member

Hi All,

I am trying to insert arabic data to the oracle database. When i insert arabic data it is taking unicode so burden on db increases.
Please suggest a solution ASAP.

Re: Unicode prob with arabic data in oracle [message #125696 is a reply to message #125615] Tue, 28 June 2005 15:08 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Most Arabic characters presumably use more than one byte per character. If you store a character using more than one byte, there will be some overhead. Try storing just ascii data in the same same database to compare performance with arabic characters. You need to try to make sure that un-necessary codepage conversion isn't being done. Example is Oracle has data stored in UTF8 and your Oracle client has nls_lang of UTF8, then no codepage conversion gets done. If you set client nls_lang to a compatible, but different setting, UTF8 will still undergo conversion to the client codepage.
Previous Topic: difference between oracle8,oracle8i and oracle 9i
Next Topic: SYBASE iSQL equivalent of SQL "SET LINESIZE n"
Goto Forum:

Current Time: Tue Jun 06 20:44:08 CDT 2023