| Unicode prob with arabic data in oracle [message #125615] |
Tue, 28 June 2005 01:25  |
kiran_madu
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.
Kiran
|
|
|
|
| Re: Unicode prob with arabic data in oracle [message #125696 is a reply to message #125615] |
Tue, 28 June 2005 15:08  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
