> SELECT ...
> FROM ...
> WHERE FIELDNAME STARTING 'Something' COLLATE NO_NO
> ORDER BY FIELDNAME
>
> works OK, whereas

Works OK? Are you saying that you see any difference between
WHERE FIELDNAME STARTING 'Something' COLLATE NO_NO
and
WHERE FIELDNAME STARTING 'Something'
(especially if Something contains national characters) ??

afaik LIKE and STARTING operators does not care about collation at all.

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

----- Original Message -----
From: "Svein Erling Tysvaer" <svein.erling.tysvaer@...>

> SELECT ...
> FROM ...
> WHERE FIELDNAME STARTING 'Something' COLLATE NO_NO
> ORDER BY FIELDNAME
>
> works OK, whereas
>
> SELECT ...
> FROM ...
> WHERE FIELDNAME STARTING :Parameter COLLATE NO_NO
> ORDER BY FIELDNAME
>
> fails on prepare (with a 'data type unknown' message). We have to use
> collate for the parameter due to the database being defined with NO_NO as
> collation and if we don't use collate, some records with Norwegian or
> Swedish characters mess up everything.
>
> Basically, we're trying to use this with the incremental searching
> facilities of IBO (well, the above mentioned test was simply done in IB_SQL
> version 4.2Fe) in a TIB_LookupCombo (yep, these details are more fit for
> ibobjects, but the problem sounds as belonging to firebird-support), and we
> use Firebird 1.0.2 Build 821 for our server. Anyone having any hints as to
> how to make this work?