|
|
Posted by Erland Sommarskog on 10/02/20 11:47
Nasir (nmajeed@prosrm.com) writes:
> I installed 2005 server with SQL_Latin1_General_CP1_CS_AS in hope to
> acheive what you described, but look what happens:
David's post may require some clarification.
In SQL Server you can set collation on three levels:
1) Server
2) Database default
3) Column level
To simplify, let's assume that server and database default are the
same.
If you want table names to be case-insensitive (which is a bad idea in
my opinion), the you install the server with a case-insensitive collation,
such SQL_Latin1_General_CP1_CI_AS or Latin1_General_CI_AS.
Then you create every table character column to be case-sensitive:
CREATE TABLE t1 (c1 char(10) COLLATE Latin_General_CS_AS NOT NULL)
Obviously, this is quite messy, since you need to specify the collation
for every column.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|