24.07.2018 14:31, eric.gueguin...@gmail.com [firebird-support] wrote: > 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 ..
First of all try to remove UPPER and put collate clause into CAST. Make sure that your connection charset is ISO8859_1, so string literal is recognized right. -- WBR, SD.
