Subject ORDER BY on BLOB
Author Kenneth Foo

Is sorting by contents of text blobs possible on IB/FB?
I tried something like this

select * from messages order by msg_from;

where msg_from is a blob field subtype 1. (Text).
What I got was totally off.
Is IB/FB sorting against BLOB ID instead?
If yes, how then do I sort by BLOB contents?


[Non-text portions of this message have been removed]