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?

Thanks in advance,
Set (and Aage)