Hi Guys,
I am having a problem with some SQL queries, I am making queries but they are coming back with null values as if there are mis-spellings in the queries. The query string is made up within the java app something like this
String sqlStatement = new String ("SELECT COUNT(*) FROM studentlist WHERE surname LIKE '%"+ nextSurname +"'");
If I print the above to the screen, then copy and past it into a query browser it works perfectly so I think it has something to do with the encoding. Does anyone have any suggestions as to what Character encoding I should use?
Dave