Java Forums

Main Menu
Home
Today's Posts
FAQ
Search
Contact Us

Java Network
Java Tips
Java Tips Blog

Sponsored Links





Welcome to the Java Forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community, you will:

  • have access to post topics
  • communicate privately with other members (PM)
  • not see advertisements between posts
  • have the possibility to earn one of our surprises if you are an active member
  • access many other special features that will be introduced later.

Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 04-28-2008, 10:17 AM
sanjeevtarar's Avatar
Senior Member
 
Join Date: Apr 2008
Location: Delhi(India)
Posts: 249
sanjeevtarar is on a distinguished road
[SOLVED] how to save hindi text into Oracle Database
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

__________________
sanjeev,संजीव
Bookmark Post in Technorati
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 04-28-2008, 11:30 AM
roots's Avatar
Moderator
 
Join Date: Jan 2008
Location: Dallas
Posts: 251
roots is on a distinguished road
never been to such situation but this might help,

Inserting UTF-8 into Oracle
__________________
dont worry newbie, we got you covered.
Bookmark Post in Technorati
Reply With Quote
  #3 (permalink)  
Old 04-28-2008, 11:59 AM
sanjeevtarar's Avatar
Senior Member
 
Join Date: Apr 2008
Location: Delhi(India)
Posts: 249
sanjeevtarar is on a distinguished road
Thanks for your reply dear.

I have done with google....and seen many article.....
__________________
sanjeev,संजीव
Bookmark Post in Technorati
Reply With Quote
  #4 (permalink)  
Old 04-28-2008, 02:59 PM
sanjeevtarar's Avatar
Senior Member
 
Join Date: Apr 2008
Location: Delhi(India)
Posts: 249
sanjeevtarar is on a distinguished road
I have solved it.

Saved Hindi into Oracle Database and retrieve successfully

__________________
sanjeev,संजीव
Bookmark Post in Technorati
Reply With Quote
  #5 (permalink)  
Old 04-29-2008, 05:38 AM
Eranga's Avatar
Moderator
 
Join Date: Jul 2007
Location: Colombo, Sri Lanka
Posts: 2,338
Eranga has a spectacular aura aboutEranga has a spectacular aura about
Send a message via Yahoo to Eranga
Quote:
Originally Posted by sanjeevtarar View Post
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.
__________________
Use an appropriate Subject. "Help, urgent!" isn't one.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Has someone helped you? Then you can
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
their helpful post.

Want to make your IDE the best?
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Bookmark Post in Technorati
Reply With Quote
  #6 (permalink)  
Old 05-02-2008, 08:07 AM
sanjeevtarar's Avatar
Senior Member
 
Join Date: Apr 2008
Location: Delhi(India)
Posts: 249
sanjeevtarar is on a distinguished road
Quote:
Originally Posted by Eranga View Post
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....



__________________
sanjeev,संजीव
Bookmark Post in Technorati
Reply With Quote
  #7 (permalink)  
Old 05-02-2008, 08:25 AM
Eranga's Avatar
Moderator
 
Join Date: Jul 2007
Location: Colombo, Sri Lanka
Posts: 2,338
Eranga has a spectacular aura aboutEranga has a spectacular aura about
Send a message via Yahoo to Eranga
Ah, thanks for the infor Sanjeev. I'm wondering to store Sinhala letters in a Database.
__________________
Use an appropriate Subject. "Help, urgent!" isn't one.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Has someone helped you? Then you can
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
their helpful post.

Want to make your IDE the best?
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Bookmark Post in Technorati
Reply With Quote
  #8 (permalink)  
Old 05-02-2008, 08:32 AM
sanjeevtarar's Avatar
Senior Member
 
Join Date: Apr 2008
Location: Delhi(India)
Posts: 249
sanjeevtarar is on a distinguished road
Quote:
Originally Posted by Eranga View Post
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.
__________________
sanjeev,संजीव
Bookmark Post in Technorati
Reply With Quote
  #9 (permalink)  
Old 05-02-2008, 09:05 AM
Eranga's Avatar
Moderator
 
Join Date: Jul 2007
Location: Colombo, Sri Lanka
Posts: 2,338
Eranga has a spectacular aura aboutEranga has a spectacular aura about
Send a message via Yahoo to Eranga
I'm just tiring Sanjeev. Few attempts already failed. I'll get you if I'm stuck with it.
__________________
Use an appropriate Subject. "Help, urgent!" isn't one.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Has someone helped you? Then you can
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
their helpful post.

Want to make your IDE the best?
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Bookmark Post in Technorati
Reply With Quote
Sponsored Links
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using JDBC to connect to ORACLE database Java Tip Java Tips 0 02-10-2008 12:27 PM
save file to database katerinaaa New To Java 0 08-14-2007 01:15 PM
Hibernate 2.1.8 / Oracle 10 / Tomcat 5.0.28 : Data not retrieved from the database scastro Database 4 08-09-2007 11:41 PM
How can I save the content of textfield in a text file? fred Java Applets 4 08-09-2007 02:30 PM
Writing text into an image and save it elcapi Java 2D 2 07-11-2007 08:09 PM


All times are GMT +3. The time now is 04:21 AM.


VBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright ©2006 - 2007, www.java-forums.org