Re: problem of accents on FR data
Re: problem of accents on FR data
- Subject: Re: problem of accents on FR data
- From: Stéphan Mertz <email@hidden>
- Date: Thu, 20 Dec 2012 15:31:50 +0100
Hi,
I subclass OracleExpression like this :
public class IVOracleExpression extends OracleExpression {
public IVOracleExpression(EOEntity in_entity) {
super(in_entity);
}
public String sqlStringForCaseInsensitiveLike(String in_s, String in_s1) {
String l_str = _NSStringUtilities.concat("CONVERT(upper(", in_s1, "), 'US7ASCII') LIKE CONVERT(upper(", in_s, "), 'US7ASCII')");
return l_str;
}
}
Le 14 déc. 2012 à 11:20, Raymond NANEON <email@hidden> a écrit :
> Hi List,
>
> I have a little data fetching problem. In our data base we have names with accent and other do not. So when we do a SQL request in our WHERE CLAUSE we surround the instruction with the function func_enleve_accent which removes accents.
>
> i.e
> SELECT nom, prenom WHERE upper(fonc_enleve_accents(i.prenom)) like upper(fonc_enleve_accents('severine')) )
>
> With this request we have all names with accents or not (sévérine or severine)
>
> In WO I try to reproduce the same thing but it does not work properly. When I have a name with accent like 'séverine' it works (we all names) but with 'severine' we have only name without accent.
>
> Here my qualifier
>
> // CLAUSE WHERE "PRENOM LIKE ..."
> private static EOQualifier qualForPrenomLike(String prenom) {
> String prenom_a = StringCtrl.chaineSansAccents(prenom, "?");
> return PRENOM.like(prenom).or(PRENOM.like(prenom_a));
> }
>
> How can I modify my qualifier to have the same result like SQL request?
>
> Thanks for you help
> Envoyé depuis iCloud
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden