Charset In Oracle 10g

[praveen2gupta]

Hi,

I am using oracle 10g. The charset for the database is iso-8859-1.
When I run the following command. select * from nls_database_parameters
Output is
NLS_CHARACTERSET WE8ISO8859P1

My problem is that my application accepts data from users in all Languages.I am using HTML and JSP Pages. Can I store the UTF-8 characters in this present environment. secondly how to identify the characters stored are correct
in the UTF-8 format.

[prabath]

I have the same question. Have you found the answer??

Thanks
sara

Hi,



I am using oracle 10g. The charset for the database is iso-8859-1.
When I run the following command. select * from nls_database_parameters
Output is
NLS_CHARACTERSET WE8ISO8859P1

My problem is that my application accepts data from users in all Languages.I am using HTML and JSP Pages. Can I store the UTF-8 characters in this present environment. secondly how to identify the characters stored are correct
in the UTF-8 format.

[praveen2gupta]

I have the same question. Have you found the answer??

Thanks
sara

Hi
I have found the solution of this problem. Each database is having an charset. And it is selected at the time of creating of the database. Charset decides what language your databse can support.

Now you will have to create a new databse with utf-8 charset option at the time of installing the database. This is the solution of the problem.

[prabath]

Thanks for the quick answer.

I found in my case that my tables will be along with many other tables which already exists in a database. So noway i can ask the admin to change the charset for the database.

But fortunately, my application needs to support only German (for time being). So i moved from UTF-8 and explicity specified ISO-8859-1 encoding in all my struts Form reset() method for request object. For JSP, I set in the encoding in page directive to same ISO-8859-1. It works fine in development env. Looking for answers from the client...

thanks once again

Hi
I have found the solution of this problem. Each database is having an charset. And it is selected at the time of creating of the database. Charset decides what language your databse can support.

Now you will have to create a new databse with utf-8 charset option at the time of installing the database. This is the solution of the problem.