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