By example how to do that : SELECT IDSYSCONFGROUP FROM SYS_CONF_GROUP WHERE UPPER(CAST(SYSGROUP_NAME AS VARCHAR(100) CHARACTER SET ISO8859_1) COLLATE FR_FR_CI_AI) = 'CAMERA'
SYSGROUP_NAME can be written like this : caméra, camera,camèra,camêra .. Other case, I load all country's name in a memory dataSet and the function locate is not accent insensitive, so my users would have all country name in upper case without acccent to do search
