On Thu, Jan 17, 2008 at 10:43:20AM -0500, Fowler, Jeff wrote:
> I've used SQL Server for over 15 years, Oracle off & on when I have no
> choice, but SQLite for a couple weeks. I've just learned (today) that
> SQLite respects trailing spaces when comparing two character fields.
> I.e. 'SQLITE' <> 'SQLITE '
>
> Is this behavior intentional? Neither SQL Server nor Oracle do this.
> Just curious as to why it works this way.
PostgreSQL sees the strings that way too:
mydbase=> select 'str' = 'str';
?column?
----------
t
(1 row)
mydbase=> select 'str' = 'str ';
?column?
----------
f
(1 row)
Those are different strings, anyway. Can't recall now, does there any
setting to change this - but you can easily find out at their website.
--
pozdrawiam / regards
Zbigniew Baniewski
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
