case-sensitive

case-sensitive

Post by Farhan Iqb » Sun, 10 Oct 2004 16:23:10


how can I change my database case-sensitive in lower case
 
 
 

case-sensitive

Post by Paul Ibiso » Mon, 11 Oct 2004 18:53:19

Have a look in BOL for 'collations'.
You can use ALTER DATABASE to change the database collation, which will then
apply to any future textbased columns created in that database.
If you already have a table with some text columns in it, you can use ALTER
TABLE to change the collation.
BTW, the only collation you can't change directly is the server one but
rebuilding the master database will allow this to be achieved indirectly.
HTH,
Paul Ibison

(recommended sql server 2000 replication book:
http://www.yqcomputer.com/ )

 
 
 

case-sensitive

Post by Derrick Le » Mon, 18 Oct 2004 07:57:23

Before you do this, be aware that it can be a big deal. If you have any
indexes on columns that have the old collation, you will need to drop them,
alter the collation on the table columns, the recreate the indexes. This
process can be very time consuming on really large databases. This includes
ANY text, char, or varchar columns and their unicode equivalents.




then
ALTER