Forums | Help | Site Map

Join Bytes
Login

network: 226,384 (2953 online)

bytes

MS SQL in Case Sensitive

sravan47 is offline

Newbie

Join Date: Nov 2008

Posts: 1

#1: Nov 6 '08

can anyone help me how can i install in MS SQL 2005 as Case-Sensitive

code green code green is offline

code green is offline

Expert

Join Date: Mar 2007

Location: England

Posts: 1,078

#2: Nov 6 '08

re: MS SQL in Case Sensitive

Case sensititvity is defined by COLLATION.
use COLLATE in queries to cast the strings

ck9663 is offline

Expert

Join Date: Jun 2007

Posts: 1,925

#3: Nov 6 '08

re: MS SQL in Case Sensitive

Maybe it's the same way as SQL 2000.

Try this

-- CK

Reply

« previous question | next question »

Similar Microsoft SQL Server bytes

MySQL to MS SQL Conversion (insights)
How to fill a Dataset with case sensitive primary keys using a OleDbDataAdapter (answers)
HELP! Case insensitive database on case sensitive server (answers)
Make MS SQL Server case-sensitive (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,384 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml

it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved