>
> How did you register the collating sequence? Did you use the
> SQLITE_UTF16_ALIGNED argument on the 3rd parameter?
>
I am doing the below.
sqlite3_create_collation(db, "PATH", SQLITE_UTF16, NULL, _cmp);
I changed it to use "SQLITE_UTF16_ALIGNED" but it didn't load properly.
I modified my extension init func to print out the return code of
create collation:
int rc;
SQLITE_EXTENSION_INIT2(pApi)
rc = sqlite3_create_collation(db, "PATH", SQLITE_UTF16_ALIGNED,
NULL, _cmp);
fprintf(stderr, "collation create: %d\n", rc);
sqlite> pragma encoding = 'utf16le';
sqlite> select load_extension('path.dll');
collation create: 0
sqlite> create table test (str collate path);
SQL error: no such collation sequence: path
sqlite>
If I set it back to SQLITE_UTF16, it recognizes the "path" collation again.
csmith
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
