This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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.