RE: [Q] ORACLE text string search case problem???

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Thu, 06 Dec 2001 15:37:52 -0800
Message-ID: <F001.003D6A43.20011206102923@fatcity.com>

There are two solutions:
a) Function based index on UPPER(required column) b) Upgrading MS Access to support unlimited users on SUN Solaris.

Do not forget to buy the row-locking option.

-----Original Message-----
Sent: Wednesday, December 05, 2001 5:10 PM To: Multiple recipients of list ORACLE-L

We have third party application, while doing text string search, user need type in upper case otherwise nothing display. The vendor said it is ORACLE problem, because "MS Access" do NOT have this problem. Because we does NOT have application source code, does their has way We can setup parameter on "init.ora" file to make it work or not?

Our ORACLE version is 8.1.7 on SUN Solaris.

Thanks.

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: dist cash
INET: mccdba_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Gogala, Mladen
INET: MGogala_at_oxhp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------