Integration

HI,

I need some help for configuring Arabic support.I am describing various configuration I have tried till today

Oracle Database: I am using 10g database.we have did following configuration on database

1. NLS_LANGUAGE = AMERICAN
2. NLS_TERRITORY = AMERICA
3. NLS_CHARACTERSET = AR8ISO8859P6 as well as AR8MSWIN1256

Database store Arabic data if data entered through sqlplus & web site on windows (which will be deployed on IIS server). if data entered through same website but deployed on sun one asp server (solaris machine), junk characters are going into database.

On solaris machine:
1. NLS_LANG : AMERICAN_AMERICA.AR8MSWIN1256
2. Arabic language package is installed on Solaris machine

On client (from where web site is accessed):

1. NLS_LANG : AMERICAN_AMERICA.AR8MSWIN1256
2. Arabic regional settings are installed on client machine.

Following encoding is tried on web server & web pages (in <meta> tag) :
UTF-8 and Cp1256 (encoding for arabic data)

We got some breakthrough using above configuration, but not complete solution.
: when Arabic data is entered through JSP web application into database.Arabic data is saved as it is.But when we Fetch same data from database and
display on page then junk characters displayed. For this we set parameter encoding to Cp1256 in deployment descriptor of JSP web application

If same data is displayed on page before saving into database then also junk characters are displayed on page

If we try to display Arabic static data written in html tags and JSP code.then also junk characters displayed on page


Please help me to solve this problem.Its very URGENT

Let me know if you need any help from my side



Thanks & Regards,
LMB