OraFAQ Forum: SQL & PL/SQL » case insensitive search UPPER/LOWER() vs. NLSSORT

Home » SQL & PL/SQL » SQL & PL/SQL » case insensitive search UPPER/LOWER() vs. NLSSORT (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

case insensitive search UPPER/LOWER() vs. NLSSORT [message #612503]

Sun, 20 April 2014 08:55

rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg

Senior Member

Hi

I learned about COLLATE in MS SQL and googled for an equivalent in Oracle.

http://stackoverflow.com/questions/507504/accent-and-case-insensitive-collate-equivalent-in-oracle

I learned in Oracle books to do a case insensitive search with UPPER() or LOWER(). Never heard of NLSSORT.

What's the Oracle way to do a case insensitive search? How you do?

Report message to a moderator

Re: case insensitive search UPPER/LOWER() vs. NLSSORT [message #612504 is a reply to message #612503]

Sun, 20 April 2014 09:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>What's the Oracle way to do a case insensitive search?
SEARCH is a totally different animal than SORT (a.k.a, COLLATE)

what problem are you really trying to solve

Please follow Posting Guidelines by posting test case & desired results

Report message to a moderator

Re: case insensitive search UPPER/LOWER() vs. NLSSORT [message #612506 is a reply to message #612503]

Sun, 20 April 2014 09:19

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

rc3d wrote on Sun, 20 April 2014 19:25

Never heard of NLSSORT.

What's the Oracle way to do a case insensitive search? How you do?

You can have look at my post Case insensitive sorts and compares. Let me know if you have any questions.

Report message to a moderator

Previous Topic:	Transpose query help
Next Topic:	How to join two table with no duplicate

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 23:46:38 CDT 2024