Hello All, 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. Thanks, - Jeff
- [sqlite] SQLite character comparisons Fowler, Jeff
- Re: [sqlite] SQLite character comparisons Zbigniew Baniewski
- RE: [sqlite] SQLite character comparisons Fowler, Jeff
- Re: [sqlite] SQLite character comparisons Zbigniew Baniewski
- Re: [sqlite] SQLite character comparisons Darren Duncan
- RE: [sqlite] SQLite character comparisons Fowler, Jeff
- RE: [sqlite] SQLite character comparisons Darren Duncan
- RE: [sqlite] SQLite character comparis... Fowler, Jeff
- Re: [sqlite] SQLite character com... Doug Currie
- Re: [sqlite] SQLite character com... Jay Sprenkle
- RE: [sqlite] SQLite character... Fowler, Jeff