@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 protected]> 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 protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca > > This email sent to [email protected] > > > -- 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]
