To case sensitive or not to

Question

To case sensitive or not to

NeoNash

SSC Eights!

Points: 914
More actions
April 19, 2002 at 1:24 pm

#104842

I would like to get your expert opinion on the case-sensitive and case-insensitive installations.
For example, Oracle installations are always case-sensitive in general (may be with some specifics).
Which one should be recommended?
What are the advantages and disadvantages?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Andy Warren SSC Guru Points: 119902 More actions · Answer 1

I see no advantage to setting something to case sensitive. At times it may make sense for a column or two, but hardly ever would you want TSQL in a stored proc to be case sensitive. You'll find some info in my article from last year, along with the associated discussion:

http://www.sqlservercentral.com/columnists/awarren/worstpracticesmakingdatabasescasesensitiveoranythi.asp

Andy

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter

NeoNash SSC Eights! Points: 914 More actions · Answer 2

I am sorry this should have gone under "General" topic and I hope you don't mind.

Thanks,

NeoNash

NeoNash SSC Eights! Points: 914 More actions · Answer 3

Thanks Andy,

That was quick and I will go through the article.

NeoNash