Re: Oracle searching with accented characters
Re: Oracle searching with accented characters
- Subject: Re: Oracle searching with accented characters
- From: Amiel Montecillo <email@hidden>
- Date: Tue, 8 Jun 2010 02:59:50 -0700
@Andrew - that is certainly a plausible approach and might end up doing. Going to give this some time.
@Pascal - in my case yes, the plain old fetch spec didn't work. Like i said in the example, searching for %pe% did not return rows with pépé.
Thanks,
Amiel
On Mon, Jun 7, 2010 at 4:41 AM, Pascal Robert
<email@hidden> wrote:
You're sure than a plain old fetch spec is not working? Our Oracle DB is full of French chars and EOF queries with accented chars works just fine without altering the session settings or passing params to the JDBC driver.
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)
This email sent to email@hidden
--
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