Home » RDBMS Server » Server Administration » To write Bangla Language in Oracle 10gR1 , 10gR2 and Express .(2 Merged) (10gR1,10gR2,Express)
To write Bangla Language in Oracle 10gR1 , 10gR2 and Express .(2 Merged) [message #554818] Thu, 17 May 2012 11:50 Go to next message
daqpeon@gmail.com
Messages: 8
Registered: May 2012
Location: Bangladesh
Junior Member
Hi,
I am from Bangladesh.Our Language is Bangali/Bangla. I tried more to write Bangla in Oracle 10gR1, or 10gR2 or Express but faild.
When I write bangla in the "emp_name" field for employee name this can be save, But when I execute to see the data again then the data comes with a big change like some symbol for some character.

If there is any solution please help me by mentioning step by step in details.




Babu
To write Bangla Language in Oracle 10gR1 , 10gR2 and Express . [message #554819 is a reply to message #554818] Thu, 17 May 2012 12:00 Go to previous messageGo to next message
daqpeon@gmail.com
Messages: 8
Registered: May 2012
Location: Bangladesh
Junior Member
Hi,
I am from Bangladesh.Our Language is Bangali/Bangla. I tried more to write Bangla in Oracle 10gR1, or 10gR2 or Express but faild.
When I write bangla in the "emp_name" field for employee name this can be save, But when I execute to see the data again then the data comes with a big change like some symbol for some character.

If there is any solution please help me by mentioning step by step in details.

Re: To write Bangla Language in Oracle 10gR1 , 10gR2 and Express . [message #554820 is a reply to message #554819] Thu, 17 May 2012 12:03 Go to previous messageGo to next message
BlackSwan
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

post SQL & results as customized to meet you situation

SELECT ASCIISTR(BENGLA_COL) FROM BANGALI_TBL WHERE ID = 1;

COPY the SQL & results then PASTE all back here
Re: To write Bangla Language in Oracle 10gR1 , 10gR2 and Express .(2 Merged) [message #554824 is a reply to message #554818] Thu, 17 May 2012 12:47 Go to previous message
Michel Cadot
Messages: 67809
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
If there is any solution please help me by mentioning step by step in details.


First your database needds to understand the character you enter otherwise it converts it to a default character.
Then your client tool to write and read the data must understand and send to Oracle these characters.
Then your Oracle client must be configured for this character set.

Regards
Michel
Previous Topic: block corruption, segment not found
Next Topic: What actually by default BLOB siz indicating. [merged 4 by jd]
Goto Forum:
  


Current Time: Mon Apr 12 01:46:16 CDT 2021