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

[Raymond NANEON]

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 <rnan...@me.com> a écrit :

Hi Stephan,

I added the _expression_ ERXJDBCAdaptor.setExpressionClassName("com.resurgences.utils.IVOracleExpression", "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 <rnan...@me.com> 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 <s.me...@improve.fr> 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 <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