• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: problem of accents on FR data
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


  • Follow-Ups:
    • Re: problem of accents on FR data
      • From: Raymond NANEON <email@hidden>
References: 
 >problem of accents on FR data (From: Raymond NANEON <email@hidden>)

  • Prev by Date: Re: SWIG framework in a WebObjects Application
  • Next by Date: Re: problem of accents on FR data
  • Previous by thread: problem of accents on FR data
  • Next by thread: Re: problem of accents on FR data
  • Index(es):
    • Date
    • Thread