we have fields containing chinese characters in our database table (Oracle 10G). From the UI, we are sending chinese character to JAVA code and trying to look-up against the table column using JNDI-JDBC connection pooling but are unable to fetch any record. Could anyone help me in this issue? I suspect, encoding might be the culprit.
Can you show the JDBC Statement you are using to retrieve this value ?
Joined: May 31, 2010
strBankBranchCodes = "SELECT bank_code, bank_name, branch_code, branch_name FROM BRANCHTABLE ";
strBankBranchCodes += "WHERE UPPER(bank_name) LIKE '%" + strSearchKey +"%' OR UPPER(branch_name) LIKE '%" + strSearchKey+ "%'";
stmt = conn.createStatement();
rs = stmt.executeQuery(strBankBranchCodes);
where strSearchKey is the Chinese string coming in from the user.
BRANCHTABLE is a synonym to an actual table.