Xref: alice comp.databases.oracle.server:20319
Path: alice!news-feed.fnsi.net!ais.net!uunet!in2.uu.net!news.superstream.net!dlabelle@solect.com
From: Tim Romano <tim@superstream.net>
Newsgroups: comp.databases.oracle.server
Subject: SQL Mystery : Bug in latest SQO32_73.DLL?
Date: Tue, 05 May 1998 18:09:33 -0400
Organization: www.superstream.net/~tim
Lines: 33
Message-ID: <354F8E1D.ABE319A2@superstream.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.05 [en] (WinNT; I)

Running Oracle 7.3 Workgroup for NT Server.

MyTable T has these columns:

ID	VARCHAR2(3)
AGENT	VARCHAR2(5)

select * from MyTable T
where T.ID = '059'
and T.AGENT = '1111'

returns null set.  BUT

select * from MyTable T
where T.ID = '059'
and T.AGENT = 1111

returns many rows. 

Am I missing something very simple? Both columns are
VARCHAR2.
Query executed from SQL Plus 3.3.  Query also executed from
TOAD.
Query also executed from MS-Access via ODBC. All three tools
yield identical results. 

The only thing that has changed on our system was the
installation today of Oracle's latest ODBC driver for 32-bit
Windows, and the existing SQO32_73.DLL file was replaced as
part of the installation.

TIA,
Tim