Finding for characters > 127 on XP

[Francois Van Lerberghe]

le 13-02-03 10:47, Ruslan Zasukhin <sunshine at public.kherson.ua> a écrit :

> on 2/13/03 12:31 PM, Vincent Mercey at v.mercey at manadgers.com wrote:
> 
>> OK, you are right.
>> The problem seems to come from uppercase("Méd")
>> 
>> Now, if do that
>> 
>> SELECT Distinct RecID,Nom,Prenom,Sexe FROM TBLIdentite WHERE RubriqueA like
>> '" + "déci" + "' order by NomPur,Prenom
>> 
>> ===> Good result found
>> 
>> But I have trouble with the fact that the final user could type uppercases
>> or lowercases. He has to find the good result in each case.
>> 
>> So 
>> SELECT Distinct RecID,Nom,Prenom,Sexe FROM TBLIdentite WHERE RubriqueA like
>> '" + "méde" + "' order by NomPur,Prenom
>> 
>> ===> No result found
>> 
>> SELECT Distinct RecID,Nom,Prenom,Sexe FROM TBLIdentite WHERE RubriqueA like
>> '" + "Méde" + "' order by NomPur,Prenom
>> 
>> ===> Good result found

Don't you have to add a NO_CASE clause like that :

  SELECT Distinct RecID,Nom,Prenom,Sexe FROM TBLIdentite WHERE RubriqueA
like '" + "méde" + "' order by NomPur,Prenom NO_CASE
                                             ^^^^^^^


François Van Lerberghe
Thier Monty, 15A
B-4570 Marchin
Belgique