At 02:20 PM 19-12-01 +0000, you wrote:

>Hi all
>
>I'd like to store texts in blob. But Order by My_Blob_field doesn't
>work well, and I can't find what is the matter.
>After ordering I get this:
>
>smallint blob
> ID My_BlobField
>-----------------------------
> 1 111111
> 4 hhhhhhh
> 2 112123123123
> 3 34534534
>
>I use FB-665 on W2k. Can anyone help me? How should I do this?

Firebird doesn't "know" what is inside a blob so about the only way you could get what you are after would be to store another column (with an index) containing a varchar that is a substring of the original text, long enough to provide enough characters to determine an ordering.

regards,
Helen