Home » RDBMS Server » Server Administration » Case sensitivity
Case sensitivity [message #369355] Mon, 04 September 2000 06:21 Go to next message
Laert
Messages: 20
Registered: January 2000
Junior Member
Hi all,
Is there an idea, how I can solve following problem:

When I'm executing for example:
select * from table where name = 'something'

The string equal to name is case sensitive. How can I set all this things case insensitive in Oracle server version 8.0.5.0.0 .

Thanx in advance
Laert

Report message to a moderator

Re: Case sensitivity [message #369356 is a reply to message #369355] Mon, 04 September 2000 06:27 Go to previous message
Naveen Kumar V
Messages: 16
Registered: February 2000
Junior Member
I think this may help you to solve your problem.

select * from table where upper(name) = upper('something')

Report message to a moderator

Previous Topic: SQL
Next Topic: Snapshot too old
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 23 10:03:13 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.