Hello, > In your schema, SaleItem_SaleUUID collates using NOCASE and Picture_UUID > collates using BINARY. I think you mean SaleItem_PictureUUID, not SaleItem_SaleUUID, but yes.
> Note that I was mistaken earlier when I said that "X=Y" and "Y=X" should > result in the same answer. If X and Y have different default collating > sequences, then X=Y does not mean the same thing as Y=X and so the answers > can be different. Right, I understand. Perhaps a brief note on the docs for the query optimizer to remind people of this might be worth it - it seems slightly counterintuitive, from a 'normal' user's point of view. Many thanks for the help - much appreciated. Best wishes, Hamish _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
