At 06:44 PM 9/7/2001 +0300, raptor wrote:

>]- so what collation set I have to use for standard English...

I figured someone would ask that. Check http://www.brookstonesystems.com

>and if i use such collation set does this mean that
>LIKE NAME% and STARTING WITH will become CaseInsensitive for this column
>...

Yes.

>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..!!!

Part of the definition of a collating sequence is a way to create index
keys that produce an exact match. Neither the optimizer nor the engine
knows that the sequence is case insensitive, so they can't mess it up.


Regards,

Ann
www.ibphoenix.com
We have answers.