On Jun 7, 2005, at 6:03 PM, Richard Huxton wrote:
If you ask me (and it's too late to back out now :-) the whole behaviour of CHAR(n) is wrong, broken and just a bad idea.
Just a quick addition: AFAIK, this bad, broken behavior (I definitely agree!) is per SQL spec. :( Don't know about the LIKE operator, however.
Michael Glaesemann grzm myrealbox com ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend