I couldn’t find a way to identify those columns that actually had a character with a code point value greater than 255. As a result, I ended up writing the following. If you have better way, please reply.<\/p>\n
\r\nimport java.sql.*;\r\n\r\npublic class checkUnicode {\r\n public static void main(String args[]) {\r\n try {\r\n Class.forName(\"oracle.jdbc.driver.OracleDriver\");\r\n Connection conn = DriverManager.getConnection(\"jdbc:oracle:thin:*****\/****@******:2484\/fake_db_service\");\r\n PreparedStatement pst = conn.prepareStatement(\"select fake_col1, fake_col2 from large_fake_table sample(1)\");\r\n ResultSet rst = pst.executeQuery();\r\n String val = \"\";\r\n double tot = 0;\r\n double found = 0;\r\n while (rst.next()) {\r\n val = rst.getString(2);\r\n for (int i = 0; i < val.length(); i++) {\r\n if (val.codePointAt(i) > 255) {\r\n\t found++;\r\n System.out.println(rst.getInt(1) + \" has a code point value of \" + val.codePointAt(i));\r\n break;\r\n }\r\n }\r\n tot++;\r\n if (tot % 100 == 0) {\r\n System.out.println(\"Have checked \" + tot + \" rows, \" + ((found \/ tot) * 100) + \"% of which have unicode.\");\r\n\t}\r\n }\r\n System.out.println(\"Checked \" + tot + \" rows\");\r\n }\r\n catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"I couldn’t find a way to identify those columns that actually had a character with a code point value greater than 255. As a result, I ended up writing the following. If you have better way, please reply. import java.sql.*;…<\/p>\n