Den 2013-10-13 21:44 skrev Reinier Olislagers såhär:

>
> On 13/10/2013 20:56, Kjell Rilbe wrote:
> > Den 2013-10-13 10:56 skrev Ivan Přenosil såhär:
> > I wish the trailing whitespace semantics would never have been made
> > applicable to varchar data. I really don't see the point. In fact, since
> > the varchar type was introduced, I don't see why it would be useful at
> > all - assuming char is used only for fixed-width data (why else use char
> > and not varchar?).
>
> AFAIU, the trailing space behaveiour of varchar is part of the SQL
> standard, so not much wriggle room there...
>

I know. I just find it rather stupid. I wouldn't want FB to go against
the standard. I'd like the standard to change. But I'm pretty sure it
will never happen for legacy reasons. In essence, when varchar was
introduced, they chose to extend the trailing space behavior to that new
type, probably thinking it would make things easier for folks wont to it
from the char type. In doing so they tried to solve a temporary problem
by introducing a permanent one. Nice one...

Kjell

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64