Home » SQL & PL/SQL » SQL & PL/SQL » case insensitive search UPPER/LOWER() vs. NLSSORT (Oracle 10g)
case insensitive search UPPER/LOWER() vs. NLSSORT [message #612503] Sun, 20 April 2014 08:55 Go to next message
rc3d
Messages: 191
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?
Re: case insensitive search UPPER/LOWER() vs. NLSSORT [message #612504 is a reply to message #612503] Sun, 20 April 2014 09:01 Go to previous messageGo to next message
BlackSwan
Messages: 23158
Registered: January 2009
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
Re: case insensitive search UPPER/LOWER() vs. NLSSORT [message #612506 is a reply to message #612503] Sun, 20 April 2014 09:19 Go to previous message
Lalit Kumar B
Messages: 2544
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.
Previous Topic: Transpose query help
Next Topic: How to join two table with no duplicate
Goto Forum:
  


Current Time: Sun Dec 21 15:16:08 CST 2014

Total time taken to generate the page: 0.08796 seconds