Case and sorting/searching

[Ruslan Zasukhin]

On 9/17/04 5:30 PM, "jda" <jda at his.com> wrote:

>> So, you have
>> 
>> * field
>> 
>> * index it as case-insensitive and by words.
>>    
>> * and you need it also sort case-insensitive.
>>     so we cannot use above index, because it is by words.
>> 
>> Then yes, you will need method.
>> Its index will be used for sorting.
>> 
>> 
>> * in the future I need add algorithm of sorting without index at all.
>>   then only you will be able avoid this SortMethod.
>>   on the other hand it will be not indexed. So it can be slower.
>>   may be in some cases this will be acceptable.
>> 
>> 
> 
> That would probably be just fine for me, anyway, as long as the sort
> can be made case-insensitive.
> 
> It seems I must also use this sort method in the query itself, right

Of course

> (e.g. select id,hit,authorsMethod from authors...)? Otherwise, it
> seems I can't use the ORDER BY authorsMethod without getting an error.

Aha, you mean that you need SELECT field which is in ORDER BY?

Yes.

This is by SQL92 standard.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------