In my application i am entering a Tamil charater as "தமிழ்" and in debug mode i can see the variable some thing as "ࢰ ࢰ ࢰ ࢰ " and when it saves in Database it saves in the same format. However when it displays again browser it displays correctly in Tamil as "தமிழ்".
However they wants that to be saved in the database as exactly what we entered in Tamil "தமிழ்". can we store the exact Tamil character as such in database like this "தமிழ்"..
My JSP pages has a page encoding as UTF-8 and with valid META Tag. Also in my server i am setting request content type as UTF-8
It seems to me that if you write that character to the database and then read it back, and you get the same character back, that's all you really need. A lot of people would be overjoyed if they could just have that. You don't need to interfere with the way the database stores it -- what difference does it make anyway? And you don't really need to worry about how your debugger displays it, either; there may be various reasons why it can't render that character naturally, but since it's being handled correctly that's really a minor problem in my opinion.
Joined: Jun 10, 2005
What if the databases stores it as rubbish character.
In order to simply store it and read it the same way, the database should have the same character set to which this string's characters belong.
The answer to your question is: yes, you can save Tamil characters (or any others) in the database.
Here is some background stuff on multilingual database support in Oracle, for example. Talk to your DBA to make sure your Java client/middleware is using the same character encoding etc as the database.