24.07.2018 14:31, eric.gueguiniat@... [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.