I want to store the respective escaped unicode characters for the simplified chinese characters. The stored content is to be converted to actual simplified chinese characters and shown on browser or PDF file. When I hard code those escaped unicode characters in a program, it is working fine. But when I store it in a database; pull those esacaped unicode characters from database and try to convert them into actual simplified chinese characters, in order to show on a browser or PDF file, is not working (after converting using "UTF8", it is still displaying the escaped unicode characters whatever pulled from database not the expecting simplified chinese characters).
Can you please help me to know the reason behind this behavior (I am suspecting at database charset) and also help me to get any suggestions/guide lines/references of which meet this requirement?
Oracle 11g (22.214.171.124.0)
DB Charset & other Details:
Windows and AIX (in development environments, we are using windows 7 enterprise; in SIT, UAT and PROD environments, we are using AIX).
Charset on Windows:
Language for non-Unicode programs: English (United States)
Charset on AIX:
Note: Programming language we are using is "Java".
Actually, I am looking at different approaches in terms of ease of implementation, less cost, no maintenance problems and etc. Anyhow, I have gone through those approaches along with their respective pros and cons.
I am storing these characters as character escapes of NCRs (numeric character references) format in the database. Obviously, these characters are treated as ASCII characters from Oracle (database) perspective. But when you retrieve these characters from database and try to display on a browser, these are automatically get converted into actual (chinese) characters on browser irrespective of your web page's (HTML document's) charset. That's all.
You would need to configure the database with respective (unicode) charset in order to support the multilingual (chinese) characters.
The problem related to inserting unicode (chinese) characters into Oracle databae (11g) using SQL scripts is solved. But, there is another problem came up while retrieving those characters from database and showing them in a web page. It is showing those characters as "?????????????????" instead of "预订证券投资咨询". Please find details given below.
Database : Oracle 11g
NLS_LANG in db: AMERICAN_AMERICA.UTF8
Driver URL: jdbc:oracle:thin:@hostname:port:dbname
Driver Class Name: oracle.jdbc.OracleDriver
Table DESCRIPTIONS Structure:
Name Null Type