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)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
|