469,623 Members | 831 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Case sensitivity in SQL -- ignore

Hi,

I believe my SQL server was configured as Case sensitivity. I have a
number of stored procedures which were moved from a non-Case
sensitivity SQL server. Because of the Case sensitivity, I have to do
a lot of editing in those stored procedures. Is there a quick way to
avoid the editing?

Something like ignoring the case in one statement?

Thanks in advance, your advice will be greatly appreciated.

Mar 14 '07 #1
2 8269
On Mar 14, 11:59 pm, sweetpota...@yahoo.com wrote:
Hi,

I believe my SQL server was configured as Case sensitivity. I have a
number of stored procedures which were moved from a non-Case
sensitivity SQL server. Because of the Case sensitivity, I have to do
a lot of editing in those stored procedures. Is there a quick way to
avoid the editing?

Something like ignoring the case in one statement?

Thanks in advance, your advice will be greatly appreciated.
I think by changing the collation of your database to case
insenstitvity may help
but this may cause problems when you create #temp tables as tempdb
will have server collation

If your column and table names are in lower case , you can modify the
SP by selecting the SP and changing to lowercase (SHIFT+CTRL+L) . But
if you have string constants which need to be in uppercase , you need
to change it accordingly

M A Srinivas

Mar 15 '07 #2
>I believe my SQL server was configured as Case sensitivity. <<

As it should be; that is how Standard SQL is defined
>Because of the Case sensitivity, I have to do a lot of editing in those stored procedures. <<
Life is tough when someone screws up. You need to just do it right
and stop looking for kludges. Oh, and if yuou can kill them guy that
did this, you will probably improve the quality of your company's
software in other places as well.

Mar 16 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by NK | last post: by
32 posts views Thread by Elliot Temple | last post: by
2 posts views Thread by Barbara White | last post: by
761 posts views Thread by Neo-LISPer | last post: by
3 posts views Thread by Jason Tesser | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.