| right. Indexes in InterBase are exact match and 'a' is not the same as
'A',
| unless one defines a collation sequence that defines them to be the same.
| Thus any indexed lookup will be case sensitive, unless the column has a
| character set that has a non-case-sensitive collation.
]- so what collation set I have to use for standard English... and if i use
such collation set does this mean that
LIKE NAME% and STARTING WITH will become CaseInsensitive for this column
...
Or it can not be garanteered 'cause if column have index+collation (i.e
insensitive) but 'cause of some FB PLAN optimisation the index usage is
turned off i.e. search again become sensitive..!!!
=====
iVAN
raptor@...
=====