On 23-10-2018 17:31, Germán Balbi [email protected] [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
