Strange behaviour of Ora 9.2

From: Thomas Fricker <thomas.fricker_at_bud.bl.ch>
Date: Tue, 24 Sep 2002 08:07:06 +0200
Message-ID: <amovdv$jun$1@rex.ip-plus.net>

Hi,
I've got two instances of oracle 9.2.0.1, one on W2K and one on NT4. The data were imported from the same dump in the same way. A Table X has columns Y and Z, both of Varchar2(240). If I do the following:

SELECT * FROM X WHERE Y = 1989 and Z = 'J' on W2K i get: ORA-01722: invalid number
and on NT4 I get the rows.!!!!!

SELECT * FROM X WHERE Y = 1989
I get: ORA-01722: invalid number on both instances.

Why do I get rows on NT4 in the first example? Ther first example was also working on previous Oracle Versions (8.1.6, 8.1.7). Received on Tue Sep 24 2002 - 01:07:06 CDT