qSIListView cannot display Chinese while connecting to Oracle database 11g
qSIListView is unable to display Chinese Character when connecting to Oracle database. The Oracle database already set to display Chinese Character.
Hi, When I use qSIListView to retrieve records from Oracle database 11g, it cannot display Chinese characters and appears many “???????” the database is set to unicode I would like to clarify whether qSIListView supports unicode database? Thanks Theresa
There are various cause. Please see the resolution section for more details.
<P>1. Please make sure the Internet Explorer is set to display Unicode (Go to View | Encoding is set to UTF-8).</P> <P>2. Please check the following in the Oracle environment by running SQL*Plus. If there is already have table supporting Chinese characters, simply run a SELECT query against the table and ensure Chinese characters are displayed properly.</P> <P>SQL> CREATE TABLE unicodedata (ID NUMBER, unicodestring NVARCHAR2(100)); <BR>Table created<BR>SQL> INSERT INTO unicodedata VALUES (11, '??');<BR>1 row inserted<BR>SQL> SELECT * FROM unicodedata;<BR> ID UNICODESTRING<BR>---------- ---------------------------------------------------<BR> 11 ??</P> <P><BR>3. Once the above is confirm, please check the connection string that used in System/Service definition via the Configuration Editor tool.<BR>Typically when non-latin characters in database are not retreived correctly is due to the encoding. The 3rd party Oracle connection provider that Quick App are using enables it to use UTF-8 encoding via connection string so you should be able to fix this issue by adding "Unicode=true" to the existing connection string.<BR></P>
There are various cause. Please see the resolution section for more details.
