Thread: [SOLVED] how to save hindi text into Oracle Database
View Single Post
  #6 (permalink)  
Old 05-02-2008, 08:07 AM
sanjeevtarar's Avatar
sanjeevtarar sanjeevtarar is offline
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,संजीव
Reply With Quote