On May 22, 2008, at 2:33 PM, Doug wrote: > Besides substituting ' with '' (double single-quotes) you might also > want to > consider trimming trailing spaces. I ended up inserting strings > like 'Doug' > and 'Doug ' in a unique-indexed column. SQLite let me do it and all > was > well. One day I exported that data to MS SQL and it complained > about the > second 'Doug ' coming in because it ignores trailing spaces, so > there was an > index collision. >
If you add "COLLATE RTRIM" to your text columns, then trailing spaces will no longer make them unique and they will work like MSSQL. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
