Hello Aage,

AJ> However (here, JOURNAL.OMTALE is a blob field)
AJ> select count(*)
AJ> from JOURNAL
AJ> where OMTALE containing 'å'
AJ> gives a different answer than
AJ> select count(*)
AJ> from JOURNAL
AJ> where OMTALE containing 'Å'
AJ> The counts are 16875 and 1274 resp. - adding "collate no_no" to 'å' or 'Å'
AJ> makes no difference.
AJ> Don't ask me why.
Probably because OMTALE has no charset and collation.

AJ> So, with a char/varchar field, try to use
AJ> select count(*)
AJ> from JOURNAL
AJ> where upper(SRT_NOR collate no_no) containing 'Å'
Why not to use
where SRT_NOR containing 'Å' collate no_no
(if SRT_NOR is defined with COLLATE NO_NO already)?


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com