On 8/10/06, JP <[EMAIL PROTECTED]> wrote:
I created a table with a field and index that uses a custom collation
function MYCOLLATE.
The problem I am having is portability, I cannot perform simple selects
on the table on other sqlite based applications since the custom
collation function is not available.
Does anybody out ther know of a PRAGMA or directive or method to disable
the usage of a custom collation once created? or a way to drop it?
I believe the simpler way is to use the ".dump" command and recreate
your table from the output.
Never tested it (already knew the problem so just kept away from
collate), but if it seems to work with some corrupted databases it
should work here too.
Regards,
~Nuno Lucas
jp.