> This inconsistency bothers me: I've always thought that char(),
> varchar(), and text() are functionally interchangeable, but it seems
> that's not so.  Is this behavior mandated by SQL92?

Yes, the behavior is correct, and mandated by SQL92. 
A char would not be able to hold the information of how many trailing blanks
are user data, since it fills the column with trailing blanks.

Andreas

Fri, 03 Sep 1999 09:13:52 +0200
Andreas Zeugswetter <andreas.zeugswetter@telecom.at>
Re: [HACKERS] SELECT BUG 