It appears that I can *NOT* create a custom collation function for a column declared as an INTEGER. Well, I can create it, and prepare a statement to use it, but my custom function is *NEVER* called. Is this by design? The exact same code works for a TEXT column.
Should the sqlite3_prepare() call return an error if I try to use a custom COLLATE on an INTEGER column? If it's by design, perhaps it could be spelled out a bit better in the documentation. Thanks. -Shane
