Oracle searching with accented characters
Oracle searching with accented characters
- Subject: Oracle searching with accented characters
- From: Amiel Montecillo <email@hidden>
- Date: Mon, 7 Jun 2010 16:02:16 +0800
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden