Re: Rép : Re: problem of accents on FR data
Re: Rép : Re: problem of accents on FR data
- Subject: Re: Rép : Re: problem of accents on FR data
- From: Chuck Hill <email@hidden>
- Date: Wed, 23 Jan 2013 09:32:20 -0800
On 2013-01-23, at 5:49 AM, Raymond NANEON wrote:
> Hi All,
>
> Can I have help on my problem? I stuck on it since 3 weeks.
>
> Thanks
> Envoyé depuis iCloud
>
> Le 07 jan 2013 à 02:20, Raymond NANEON <email@hidden> a écrit :
>
>> Hi Stephan,
>>
>> I added the expression ERXJDBCAdaptor.setExpressionClassName(
>> "com.resurgences.utils.IVOracleExpression"
Is that really the package name and class that you put your code in?
Chuck
>> , "er.extensions.jdbc.ERXJDBCAdaptor"); in my Application class init method and I used these qualifiers "EOQualifier quaPrenom = EOQualifier.qualifierWithQualifierFormat(PRENOM_KEY+" LIKE %@", new NSArray(prenom));" or "PRENOM.like(prenom)" to get sqlStringForCaseInsensitiveLike method in the SQL expression but I have allways the sqlStringForCaseInsensitiveLike method of EOSQLExpression class in my SQL. Have I forget something?
>>
>> Thanks
>> Envoyé depuis iCloud
>>
>> Le 21 déc 2012 à 01:07, Raymond NANEON <email@hidden> a écrit :
>>
>>> Hi Stéphan,
>>> Thanks a lot. I am in holydays. I go to try it when I will go back at office.
>>> Have nice day
>>>
>>> Envoyé de mon iPhone
>>>
>>> Le 20 déc. 2012 à 16:25, Stéphan Mertz <email@hidden> a écrit :
>>>
>>> > And add this in the Application init to replace the original OracleExpression (you must change the IVOracleExpression class name and package with yours):
>>> > ERXJDBCAdaptor.setExpressionClassName("com.resurgences.utils.IVOracleExpression", "er.extensions.jdbc.ERXJDBCAdaptor");
>>> >
>>> >
>>> > Le 20 déc. 2012 à 15:37, Raymond NANEON <email@hidden> 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 <email@hidden> 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 <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
>>>
> _______________________________________________
> 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
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/gvc/practical_webobjects
Global Village Consulting ranks 13th in 2012 in BIV's Top 100 Fastest Growing Companies in B.C!
Global Village Consulting ranks 76th in 24th annual PROFIT 200 ranking of Canada’s Fastest-Growing Companies by PROFIT Magazine!
_______________________________________________
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