Re: Oracle SQL bug in 9.2.0.8

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Thu, 10 Feb 2011 19:25:16 +1100
Message-ID: <ij07b4$tj3$2_at_news.eternal-september.org>

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