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
 

 
 

 

Reply via email to