I see. What I couldn't understand till now is how you ended up with
such data. This explains it :-)
Andrus
On May 25, 2006, at 4:18 PM, Øyvind Harboe wrote:
> On Thu, 2006-05-25 at 16:04 -0400, Andrus Adamchik wrote:
>> 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?)
>
> I prefer HSQLDB's behaviour. That MS Access & MS SQL Server yield
> a match in this case is *stopid*.
>
> The problem is that we're trying to lift an old application from MS
> Access & MS SQL server + .asp over to Cayenne + Tapestry. While we
> are waiting for the write-from-scratch & migration to complete for
> all customers, we need to be bug-by-bug compatible with the old
> database. That might not be possible, but things will go much,
> much smoother if we can achieve it(since we don't have to
> touch the .asp + vbscript code then). We have also have
> some particularly imaginative and unusual plans for those
> "developers" that "exploited" this particular quirk in MS Access/MS
> SQL
> server :-)
>
> Once the migration is complete, we'll toss out MS Access & MS SQL
> server.
>
>
> --
> Øyvind Harboe
> http://www.zylin.com
>
>
This archive was generated by hypermail 2.0.0 : Thu May 25 2006 - 16:22:13 EDT