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