> create table blobtable (blobfield blob sub_type text character set
> ISO8859_1 collate EN_US);
> insert into blobtable(blobfield) values('Row 1');
> insert into blobtable(blobfield) values('Row2');
> select * from blobtable order by blobfield asc;
>
> In order to do this ordering, the engine MUST care about the format
> of the data in the blob.

The ordering by blob column is not supported yet
(it will sort by blob-ids). But you can cut appropriate part
of blob content using SUBSTRING and order by that string.

Ivan
http://www.volny.cz/iprenosil/interbase/