Re: VARCHAR and trailing space

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu May 25 2006 - 16:04:05 EDT

  • Next message: Øyvind Harboe: "Re: VARCHAR and trailing space"

    On May 25, 2006, at 1:34 PM, Øyvind Harboe wrote:

    > 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>"

    And why should it? The two are not equal. (this is VARCHAR's, right?)

    Do you have that test case that actually shows what problems it
    causes in Cayenne?

    Andrus

    This archive was generated by hypermail 2.0.0 : Thu May 25 2006 - 16:04:29 EDT