Re: Case sensitivity with PostgreSQL and WO5.x
Re: Case sensitivity with PostgreSQL and WO5.x
- Subject: Re: Case sensitivity with PostgreSQL and WO5.x
- From: Stirling Olson <email@hidden>
- Date: Tue, 23 Nov 2004 11:47:06 -0700
Like is case sensitve. You should substitute 'CaseInsensitveLike' for
'Like' in your EO model and/or qualifiers.
-Stirling
On Nov 23, 2004, at 11:20 AM, Mez wrote:
Hi,
Has anyone had problems with LIKE searches yielding case sensitive
results?
My WOApp used to work fine with Openbase, but with pgsql I now have to
be aware that searches are case sensitive - which is not
desired/desirable at all in my case. Even if it is SQL92/99 compliant.
I've compiled version 7.4.6 on MacOS X 10.3.6 and also built Kenny
Leung's generously provided EOModeler plugin and the accompanying
framework, and otherwise PostgreSQL works fine.
As a workaround, I've tried to use raw SQL in EOModeler, when setting
up a fetch specification, but although this seems to yield the correct
behaviour in EOModeler, it causes syntax errors in WO when running the
application.
I've also tried amending the plugin and framework to use different
escape characters, but I get the same problem.
Any solutions/ideas?
TIA,
Mez
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden
This email sent to email@hidden
_______________________________________________
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