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
--
Mark Rotteveel