Thread

Re: [HACKERS] SELECT BUG

Zeugswetter Andreas <andreas.zeugswetter@telecom.at> — 1999-09-03T07:13:52Z

> 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