Ol'SureHand (8/3/2009)

---

Jeff Moden (9/13/2008)

---

Jack Corbett (9/13/2008)

---

[Jack said:] [ANSI_PADDING] is turned off by default at the Database level, which is odd considering the ability to turn it off is going to be deprecated. Oh well, who said MS had to be consistent?

Heh... I wish MS would stop deprecating useful things.

Guys, can we do anything about it? Like write to Microsoft or something?

If ANSI_PADDING OFF is deprecated, and the ON becomes the only setting, I reckon that eliminates the difference between CHAR and VARCHAR.

Why bother having 2 data types that behave the same way and use the same amount of space. . . oh, that's not so, in the case of VARCHAR, it will use 2 extra bytes for the length!!!!!