Re: [sqlite] Collation & blobs

2008-06-12 Thread Alex Katebi
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

Re: [sqlite] Collation & blobs

2008-06-12 Thread D. Richard Hipp
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 co

[sqlite] Collation & blobs

2008-06-12 Thread Alex Katebi
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? One can format a blob with route