Hi Guys,

I am currently in a battle with searching the db and accented characters.

We have some data having accented characters like pépé

I need pépé to be included in the result set when I query select * from
persons where firstname like '%pe%'

So I need to set the following on oracle

alter session set NLS_SORT=GENERIC_M_AI;
alter session set nls_comp=LINGUISTIC;

This works but I do not know how to set this with webobjects or if it is
even advised. I wonder how you guys handle this using WO?

Can anyone shed some light on my dark day please?

Thanks,
Amiel

-- 
socket error: unable to connect to 127.0.0.1
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to