Re: EQUAL_TO with CHAR problem in Oracle

From: Robert John Andersen (robert_anderse..ridge-point.com)
Date: Sat May 04 2002 - 14:37:53 EDT

  • Next message: Robert John Andersen: "Re: Multiple datasources for a map"

    can and will

    On Sat, 2002-05-04 at 13:07, andrus wrote:

        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 - 14:45:52 EDT