Hi,
I'm facing a strange behavour from Firebird 1.5:
It's about using Concatenation opérator (||) when used with combined
types, integer and varchar. The varchar contains "accentuated"
characters (à,é, etc. ...). My database is based on ANSI_CHARSET charset.

this works fine:
Select 1 || ' Chèque' from rdb$database

BUT this does not work
Select * From SP_PIPE(1,' Chèque');

here the proc script:
SP_PIPE.SQL
-----------
COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;
DROP PROCEDURE SP_PIPE ^
CREATE PROCEDURE SP_PIPE(Entier Integer, Chaine Varchar(20))
RETURNS
(
Retour VARCHAR(100)
)
AS
BEGIN
Retour = Entier || Chaine;
SUSPEND;
END
^

SET TERM ; ^
COMMIT WORK;
SET AUTODDL ON;