The query below returns 3 rows. I presume it is as designed, but i'm
reporting just to make sure:

recreate table test1 (
id integer,
column1 blob sub_type 1 );

insert into test1 values (1, 'asdfg');
insert into test1 values (2, 'asdfg');
insert into test1 values (3, 'asdfg');

select distinct
column1
from
test1;

Regards,

Fabiano