[SOLVED] how to save hindi text into Oracle Database

[sanjeevtarar]

Hello All,

I need to save Hindi value/Other then English in Oracle DataBase using java.

What changes i need to make in DB.?

Does anybody have any idea about this.


Your valuable Ideas are Welcome.


Thanks

[roots]

never been to such situation but this might help,

Inserting UTF-8 into Oracle

[sanjeevtarar]

Thanks for your reply dear.

I have done with google....and seen many article.....:(

[sanjeevtarar]

I have solved it.

Saved Hindi into Oracle Database and retrieve successfully

[Eranga]

I have solved it.

Saved Hindi into Oracle Database and retrieve successfully

Congratulations Sanjeev,

Can you explain a little more that how did you do it. I like to store some Sinhala letters into a database.

[sanjeevtarar]

Congratulations Sanjeev,

Can you explain a little more that how did you do it. I like to store some Sinhala letters into a database.

Ya Eranga,

replying very late.....

Just create a Unicode database in Oracle using NLS_CHARACTERSET = 'UTF8' and use the NVARCHAR2 data type to store values.

However i found some article that says you can store Unicode in Unicode database (NLS_CHARACTERSET = UTF8) or also in non-Unicode database(NLS_CHARACTERSET = WE8MSWIN1252).

I was trying on that but not able to store Unicode value (Hindi in my case).

more info....

[Eranga]

Ah, thanks for the infor Sanjeev. I'm wondering to store Sinhala letters in a Database.

[sanjeevtarar]

Ah, thanks for the infor Sanjeev. I'm wondering to store Sinhala letters in a Database.

Have done with your code.....

If you got any doubt or any problem feel free to ask.

[Eranga]

I'm just tiring Sanjeev. Few attempts already failed. I'll get you if I'm stuck with it.

[ishwarbansal]

i want to save hindi text using java in oracle.
How can i do it?

I have solved it.

Saved Hindi into Oracle Database and retrieve successfully

[rajeshgite]

hi sanjeev sir
I am tring to read hindi text using java and my assignment is to store these in in postgres DB as english so what changes i have to do in my code???
please help me sir.....

[rajeshgite]

Sanjeev sir,
i have vb code in that finding the ASCII char of hindi text. but my project is in java. can u please tell me how to call vb function from java code..

[Eranga]

Actually this is very old thread, Sanjeev start this more than two years ago. It's already marked as solved too. So why don't you start a new thread in relevant sub-forum.

[rajeshgite]

hi Eranga,
Do you know the ans of my q????
then please reply me otherwise not...

[Eranga]

If you do it in proper way, yes I can. But not like this.

Please don't continue this discussion since your question is not relevant to the title.