On Mon, Mar 29, 2010 at 12:16:57PM +0200, Rickard Utgren scratched on the wall: > On Mon, Mar 29, 2010 at 12:07, Dan Kennedy <danielk1...@gmail.com> wrote: > > > This database was created with a different version of the collation > > sequence than found in the script. I think the -nocase switch was > > probably passed to [string compare].
> I didn't realize this would matter, but at least now I don't have to > worry about my code breaking it again, thanks. If you change a collation that is used in an index, you must rebuild the index. That's what the VACUUM command is doing, and why it is "fixing" the problem. You can do this more quickly with the REINDEX command. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
