Subject Re: [firebird-support] Integer & varchar Concatenation
Author Jonathan Neve
mohamed_banaouas wrote:

>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.