Re: Oracle SQL bug in

From: Noons <>
Date: Thu, 10 Feb 2011 19:25:16 +1100
Message-ID: <ij07b4$tj3$>

Geoff Muldoon wrote,on my timestamp of 10/02/2011 4:54 PM:

> Someone else may be able to confirm that this is an acceptable
> interpretation of the ANSI SQL99 standard for the comparison of CHAR
> elements of unequal length where trailing whitespace only occurs.
> Oracle seems to default strings in where clauses as CHAR.
> The same behaviour does not happen for VARCHAR or VARCHAR2 elements, at
> least in 11.2.

Actually, if someone read the manual paragraph I pointed out, it'd be very clear what is going on. It's got nothing to do with SQL99. Received on Thu Feb 10 2011 - 02:25:16 CST

Original text of this message