On 24-7-2018 16:46, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 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.
The collate clause is not supported within CAST (which is an interesting omission). It should be sufficient - assuming SYSGROUP_NAME already is ISO8859_1 - to use SYSGROUP_NAME collate FR_FR_CI_AI = 'CAMERA' Otherwise CAST(SYSGROUP_NAME AS VARCHAR(100) CHARACTER SET ISO8859_1) COLLATE FR_FR_CI_AI = 'CAMERA' -- Mark Rotteveel
