|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
December 2nd, 2004, 05:15 AM
|
|||
|
|||
|
case insensitivity in MS SQL
After reading up, I realised that MS SQL can be set to be case sensitive and case insensitive.
This is done at installation/setup time. My MS SQL is set up to be case sensitive. Is it possible to change this to case insensitive? Although, what I would really need is just for a particular database (or possibly tables) to be case insensitive and for others to stay case sensitive. Is it possible to create a database or tables to be case insensitive within a case sensitive MS SQL? Thank you, ludmann
|
|
#2
December 2nd, 2004, 05:17 AM
|
||||
|
||||
|
You can do it choosing the collation, (CI = case insensitive, CS = case sensitive) but read http://databasejournal.com/features...cle.php/1587631
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > case insensitivity in MS SQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
