Q: How to ignore accent sensitive in java.sql.Statement.executeQuery() I'm using ResultSet java.sql.Statement.executeQuery(String sql) throws SQLException
When I call this method, it is accent sensitive. How can I ignore this ?
String nom = "Labbe";// i want to find here "Labbe" and "Labbé" !
ResultSet resultSet = statement.executeQuery("Select * from Personne P Where P.nom = "+ nom);


A: You need to precede the statement with a PRIMARY strength for FRENCH or maybe ENGLISH.
SET COLLATION FRENCH STRENGTH PRIMARY;

See set collation. This will also help for list ordering, when not defined on the database schema.
