Rép : Re: problem of accents on FR data

[Raymond NANEON]

Hi List,

Happy new year, all my best whishes.

So stéphan, I am back to my office and I would like to know How I use sqlStringForCaseInsensitiveLike (return String) method as a EOQualifier method?

Thanks

Envoyé depuis iCloud

Le 20 déc 2012 à 06:37, Raymond NANEON <rnan...@me.com> a écrit :

Hi Stéphan,

Thanks for your help and I want to know if it returns rawrowSql or EOEntity data? 

How can I use this class in my EOQualifier _expression_? An example I mean

Ray

Envoyé depuis iCloud

Le 20 déc. 2012 à 15:31, Stéphan Mertz <s.me...@improve.fr> a écrit :

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 <rnan...@me.com> 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      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/s.mertz%40improve.fr

This email sent to s.me...@improve.fr

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/rnaneon%40me.com

This email sent to rnan...@me.com

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com