Home » RDBMS Server » Server Administration » SQL and Upper/Lower case sensitivity
SQL and Upper/Lower case sensitivity [message #370772] Thu, 03 February 2000 19:29 Go to next message
Sara Lindberg
Messages: 1
Registered: February 2000
Junior Member
I am designing an ASP interface for either Access, SQLServer or Oracle, depending upon the end user's database. I have found that my SQL statements are case sensitive when tested on an Oracle DB--is there any thing I can do on my side to get around this or does the problem lie in the database?
Re: SQL and Upper/Lower case sensitivity [message #370775 is a reply to message #370772] Fri, 04 February 2000 19:34 Go to previous message
Paul
Messages: 164
Registered: April 1999
Senior Member
Sara,
Oracle reserved words, table names, and column names are not case sensitive; SELECT TABLE_NAME FROM USER_TABLES works the same as select table_name from user_tables. Values in character fields are case sensitive, if a name is stored as 'SMITH', then WHERE name = 'Smith' will not find it.
Hope this helps,
Paul
Previous Topic: Re: Creating an ASCII file (line size -- 20000 chars) in PL/SQL
Next Topic: URGENT Syntax question Dynamic SQL.
Goto Forum:
  


Current Time: Tue Oct 20 09:59:54 CDT 2020