On Thu, 2006-05-25 at 10:36 -0400, Andrus Adamchik wrote:
> VARCHARs normally should not be trimmed (at least not by the
> framework). It as assumed that database does not pad VARCHARs with
> spaces, as this goes against the definition of VARCHAR (unlike CHARs
> where the behavior is undefined). So trailing spaces are assumed to
> have meaning to the user.
Good. This lines up with my understanding.
> This is why I was surprised by your report
> that MS Access does in fact pads VARCHARs. Maybe it simply doesn't
> support this data type?
NB!!! MS SQL server behaves the same way as MS Access. NB!!!
In my tests HSQLDB will not yield a match for WHERE "foo"="foo<space>"
As far as I can tell MS Access supports VARCHAR just fine.
-- Øyvind Harboe http://www.zylin.com
This archive was generated by hypermail 2.0.0 : Thu May 25 2006 - 13:35:13 EDT