I can still keep my routes in text presentation notation like 1.1.0.0/16 or fe80::/16. Thanks, -Alex
On Thu, Jun 12, 2008 at 7:32 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
