Subject Re: [firebird-support] SP space chacarter problem in FB2.5
Author Mark Rotteveel
On 23-10-2018 17:31, Germán Balbi balger@... [firebird-support] wrote:
> in the netx SP send the follow parameters
> 5,' ','N' --->>>5 Años (perfect)
> 5,'','N' --->>>5 Años ( not 5Años) without space of separation >:(
> create or alter procedure VER_EDAD (
>     N_EDAD numeric(15,4),
>     SEPARADOR char(1),
>     CORTO char(1))

You will need to use VARCHAR instead of CHAR. CHAR values are **always**
padded with space up to the declared length. So if you assign '' (empty
string) to a CHAR(1), it will actually be a ' ' (single space).

This is the SQL standard defined behavior for CHAR.

Mark Rotteveel