Finding for characters > 127 on XP

[Ruslan Zasukhin]

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
> 
> 
> Consequences :
> I have to use :
>   MethodField.SetMethod("UPPER(RubriqueA)")
> 
> and the realbasic uppercase function ....
> Do I have to translate the result returned by the RB uppercase to Macos
> charset ?

No, it must not be MAcOS charset if you work on Windows.

> I do not think it is good .
> But what to do ?

You must find way how to build correct Upper() string in REALbasic,

This is question not to me.
Ask on Valentina list or on RB list.

I think you need inform in some RB also about language you use.

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------