On Sat, 2006-05-20 at 13:34 -0400, Andrus Adamchik wrote:
> Other adapters address trailing space problem by some combination of
> a trimming CharType and TrimmingQualifierTranslator (see
> SybaseAdapter and SQLServerAdapter):
I see this problem w/MS SQL server as well as MS Access. I suspect the
same problem exists with all database types and further that this
problem has nothing to do with trimming trailing space of database
fields.
The primary key is a VARCHAR, so I believe that Cayenne is correctly
translating the VARCHAR to have a trailing space.
The primary key(VARCHAR) in my case is stored *without* the trailing
space. The reference to the primary key in other tables sometimes
have a trailing space which is where the trouble starts since WHERE
"foo"="foo<SPACE>" will yield a match, whereas ObjectId will not yield
a match in this case.
>From my limited understanding of the finer points of Cayenne & SQL, I
can arrive at no other conclusion than that ObjectId's concept of
equality should match that of SQL's concept of equality in a WHERE
clause.
-- Øyvind Harboe http://www.zylin.com
This archive was generated by hypermail 2.0.0 : Sat May 20 2006 - 15:46:09 EDT