Re: EQUAL_TO with CHAR problem in Oracle

From: andrus (andru..bjectstyle.org)
Date: Sat May 04 2002 - 13:07:21 EDT

  • Next message: andrus: "Re: Nightly build problems"

    Hi Robert,

    I think we should address this in Cayenne. Could you post it as a bug at
    http://sourceforge.net/tracker/?group_id=48132&atid=452068 ?

    Thanks

    Andrus

    Robert John Andersen writes:

    > If you have a column defined as CHAR, Oracle space pads it out so you
    > can't do straight equal unless you space pad it out, this problem will
    > appear if you do LIKE as well. So the question is do I have to space
    > pad out my strings or should you do a trim in the sql?
    >
    > WebObjects 4.5X (don't know about 5.X) has the same problem.
    >
    > RJA
     

    This archive was generated by hypermail 2.0.0 : Sat May 04 2002 - 13:07:27 EDT