Subject | Re: [firebird-support] Weird behavior of case when using string as return |
---|---|
Author | Nando Dessena |
Post date | 2006-08-11T19:56:10Z |
Jiri,
J> Why is the 'short' string right-padded to length of 'looooooooong'? Can I
J> remove this spaces using some easy steps (i.e. not using rtrim UDF, ...).
I think that string literals like 'looooooooong' and 'short' evaluate
to the char type. If you want a different type (like varchar) you'll
need to cast() them.
Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================
J> Why is the 'short' string right-padded to length of 'looooooooong'? Can I
J> remove this spaces using some easy steps (i.e. not using rtrim UDF, ...).
I think that string literals like 'looooooooong' and 'short' evaluate
to the char type. If you want a different type (like varchar) you'll
need to cast() them.
Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================