| SQL and Upper/Lower case sensitivity [message #370772] |
Thu, 03 February 2000 19:29  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
