By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,365 Members | 2,946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,365 IT Pros & Developers. It's quick & easy.

Case sensitivity in SQL -- ignore

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
>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.