How to perform a search disregarding Firebird special characters in the WHERE Clause

Question

I’m making a View and Clause WHERE it does not accept a filter of this 'Temporary' only if removing the accent Ex: 'Temporario'.

CREATE VIEW VWORDEMPRODUCAO (
CODEMPRESA
)
AS
SELECT
F002 AS CODEMPRESA
FROM MFT05O020
WHERE F020 <> 'Temporário'

Thank you and I’ll be waiting.

Answer 1

I’m not familiar with Firebird, so I’m not sure if this solution is viable, but it’s worth:

CREATE VIEW VWORDEMPRODUCAO (CODEMPRESA)
AS
    SELECT  F002 AS CODEMPRESA
    FROM    MFT05O020
    WHERE   (CAST(F020 AS VARCHAR(MAX)) COLLATE SQL_Latin1_General_Cp1251_CS_AS) <> ('Temporário' COLLATE SQL_Latin1_General_Cp1251_CS_AS)

To Collation Sql_latin1_general_cp1251_cs_as removes all accented characters, thus allowing comparison without them.