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

case sensitivity

P: n/a
Is SQL server defaults to case insensitive? I am sure there are ways to
install case sensitive SQL server instance but coming from Sybase
(which is always case sensitive) case insensitivity is something new to
me (it requires coding change etc).
Besides, is there any option I can set to turn on case sensitivity or I
am stuck with it? (I can not reinstall SQL server).
Thanks.

Nov 13 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
MC
Case sensitivity is defined by Collation. Read a bit about collations and
youll see what are your options.

MC

<ot*******@yahoo.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Is SQL server defaults to case insensitive? I am sure there are ways to
install case sensitive SQL server instance but coming from Sybase
(which is always case sensitive) case insensitivity is something new to
me (it requires coding change etc).
Besides, is there any option I can set to turn on case sensitivity or I
am stuck with it? (I can not reinstall SQL server).
Thanks.

Nov 13 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.