Hello,

My Database CHARSET is WIN1252

Ex : SELECT UPPER(CAST('caméra' AS VARCHAR(100) CHARACTER SET ISO8859_1) COLLATE FR_FR)from RDB$DATABASE

FB25 => CAMERA
FB3 => CAMÉRA

Could you explain why the result of this query is not the same with FB3 and FB25 ?

I used this query to remove accent, but with FB3 it seems to not work like this

(I tried with COLLATE FR_FR_CI_AI, but same result)

Thank you

Eric