On Sun, Oct 13, 2013 at 2:56 PM, Kjell Rilbe <kjell.rilbe@...> wrote:

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?).

The problem being addressed, I think was comparing varchars to chars

or literals.  The reason octets work is that a space is just another binary

value.

Good luck,

Ann