OraFAQ Forum: Server Administration » To write Bangla Language in Oracle 10gR1 , 10gR2 and Express .(2 Merged)

Home » RDBMS Server » Server Administration » To write Bangla Language in Oracle 10gR1 , 10gR2 and Express .(2 Merged) (10gR1,10gR2,Express)

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

To write Bangla Language in Oracle 10gR1 , 10gR2 and Express .(2 Merged) [message #554818]

Thu, 17 May 2012 11:50

daqpeon@gmail.com
Messages: 9
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

Report message to a moderator

To write Bangla Language in Oracle 10gR1 , 10gR2 and Express . [message #554819 is a reply to message #554818]

Thu, 17 May 2012 12:00

daqpeon@gmail.com
Messages: 9
Registered: May 2012
Location: Bangladesh

Junior Member

Report message to a moderator

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

BlackSwan
Messages: 26766
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

Report message to a moderator

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 09:38:03 CST 2025