On Wed, 19 Oct 2005 15:40:44 -0300 (ADT) "Marc G. Fournier" <scrappy@xxxxxxxxxxxxxx> wrote: > On Wed, 19 Oct 2005, Richard_D_Levine@xxxxxxxxxxxx wrote: > > > I was referring to trailing blanks, but did not explicitly say it, > > though showed it in the examples. I am pretty sure that the SQL > > standard says that trailing whitespace is insignificant in string > > comparison. > > Then we are broken too :) > > # select 'a ' = 'a '; > ?column? > ---------- > f > (1 row) > > ---- Here MySQL(4.0.20-Max-log) answer. I'm not familiar with mysql but the result was your expect. -- mysql> select ' a' = ' a'; +--------------+ | ' a' = ' a' | +--------------+ | 0 | +--------------+ 1 row in set (0.00 sec) mysql> select ' a' = ' a'; +-------------+ | ' a' = ' a' | +-------------+ | 1 | +-------------+ 1 row in set (0.00 sec) mysql> select 'a ' = 'a '; +---------------+ | 'a ' = 'a ' | +---------------+ | 1 | +---------------+ 1 row in set (0.00 sec) mysql> -- ==Jun -- J.Kuwamura rC Cm ^ ~ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
