Software

Ask something
Discussion Locked

Case sensitive problem (Oracle database)

0 helpful
3 replies

by aruni

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm doing a search engine using java and oracle database. but when I'm dealing with SQL, there are some case sensitive problem with keywords. so, how can I slove this problem.

3 replies

by john_wills

This is not exactly a discusssion matter. It really belongs in the Technical Q & A of the sister site techrepublic.com, where lots of eager programmers lurk hoping to answer questions. I don't know the answer to your question.

by labazzo

In Oracle there are built in functions that will convert string data types to all capitals, all lower case, or even the first letter in each word. Unfortunlatly I can remember what the syntax is but you should be able to look it up easliy. Just convert to all lower case and compare the search to the data base or all capitals.

by tynant

The function names are upper(fieldName), lower(fieldName) and Initcap(fieldName)

However I would strongly recommend against using the function on the database column in the where clause unless you have functional indexing in place. The use of these without these type of indexes is seriously going to screw performance on a large database.

This discussion is closed to new replies.