Re: Oracle SQL bug in 220.127.116.11
Date: Thu, 10 Feb 2011 19:25:16 +1100
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