mohamed_banaouas wrote:

>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');
>
>

What's the error message?

Also, does it work if you manually cast the integer as a varchar?

Jonathan Neve.