CodingCase sensitivity (MS SQL)

 

Press Ctrl+Enter to quickly submit your post
Quick Reply  
 
 
  
 From:  Peter (BOUGHTONP)  
 To:  ALL
34614.1 
Does case-sensitivity make performance better/worse?

I'm specifically asking with regards to MS SQL, which is insensitive by default (unlike every other database I've ever encountered), but any general information would also be interesting.
0/0
 Reply   Quote More 

 From:  THERE IS NO GOD BUT (RENDLE)  
 To:  Peter (BOUGHTONP)     
34614.2 In reply to 34614.1 

I don't know about "default"; case sensitivity is specified by the collation, and you can set a default for the server when you set it up.

 

I'm pretty sure it doesn't make any difference to performance. I generally set it to CI_AS (case insensitive, accent sensitive) unless there's a very specific reason for case sensitivity.

 

Obviously case-insensitive searching with a case-sensitive collation (or vice-versa) is going to have performance implications.


One of us is an idiot. If it's me, I apologise. If, as I suspect, it's you, I forgive you.
0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  THERE IS NO GOD BUT (RENDLE)     
34614.3 In reply to 34614.2 
Thanks.

My (ex-dba) director said it was default... hopefully he was just simplifying, and actually knows about the collation stuff... :/
0/0
 Reply   Quote More 

Reply to All    
 

1–3

Rate my interest:

Adjust text size : Smaller 10 Larger

Beehive Forum 1.5.2 |  FAQ |  Docs |  Support |  Donate! ©2002 - 2024 Project Beehive Forum

Forum Stats