On Jun 12, 2008, at 6:35 PM, Alex Katebi wrote:
> The custom sqlite3_create_collation( ) is a perfect solution for
> implementing an Internet Protocol Routing Table.
> But I am not sure if SQLite will call a custom collation function if
> column
> values are blobs. In other word, are blobs considered for collation?
>
Blob always sort in memcmp() order. The sorting rules for SQLite are
(and always have been):
1. NULLs sort first
2. Numbers sort next in numerical order (floating point values
and integers interleave as appropriate).
3. Text sorts next in the order determined by the collating
sequence
4. BLOBs sort last in memcmp() order.
D. Richard Hipp
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
