InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 11:56:33 GMT20http://www.sqlservercentral.com/Forums/Topic683866-146-1.aspxRead about it at http://www.db-staff.com/index.php/microsoft-sql-server/69-change-collationMJFri, 27 Mar 2009 18:42:18 GMTMANU-J.http://www.sqlservercentral.com/Forums/Topic683866-146-1.aspxNote that changing server or database collation does NOT change the collation for pre-existing columns/data. There's only one way to do that:Create a brand new empty database in the desired collation and migrate the data into that DB.Simplest thing to do is to use the COLLATE option, though (as mentioned above).MSSQLTIPS just had an article on that today: [url=http://www.mssqltips.com/tip.asp?tip=1717]slightly different context but same issue[/url]Fri, 27 Mar 2009 13:13:25 GMTPam Brisjarhttp://www.sqlservercentral.com/Forums/Topic683866-146-1.aspxYou do not have to change the database or column collation in order to use different collations for specific tasks. In fact you can mix collations to match your needs.If you have your database built with case insensitve collation but would like to do case sensitive search just use the COLLATE keyword.For example the first select will find all records where test code is 'ABC' regardless of the case - so abc, AbC aBc and such will be found. The second one will find only the record matching the case of the specified string 'ABC' in this case. The third example will mix the case sensitive and case insensitive search in one query. SELECT * FROM TestsWHERE TestCode = 'ABC'SELECT * FROM TestsWHERE TestCode = 'ABC' COLLATE Latin1_General_CS_AS SELECT * FROM TestsWHERE TestCode = 'ABC' COLLATE Latin1_General_CS_AS OR TestCode = 'CBS'Fri, 27 Mar 2009 09:42:21 GMTJacekOhttp://www.sqlservercentral.com/Forums/Topic683866-146-1.aspxWhy do you want to change to case sensitive?Fri, 27 Mar 2009 06:21:24 GMTChiragNShttp://www.sqlservercentral.com/Forums/Topic683866-146-1.aspxNote that you can also change your database, or table collation as well (if you don't want your entire server running that way)So if you're using SQL_Latin1_General_CP1_CI_AS, try SQL_Latin1_General_CP1_CS_AS[quote]ALTER DATABASE COLLATE SQL_Latin1_General_CP1_CS_AS[/quote]Fri, 27 Mar 2009 05:26:47 GMTJamieXhttp://www.sqlservercentral.com/Forums/Topic683866-146-1.aspxHi,you can change the server collation, check http://msdn.microsoft.com/en-us/library/ms179254.aspxRegards,RenéFri, 27 Mar 2009 05:13:32 GMTrene-500237http://www.sqlservercentral.com/Forums/Topic683866-146-1.aspxSo whats the proble it must not show column1 when give COLUMN1.I dont think there is an option for that.Thu, 26 Mar 2009 02:54:41 GMTEswinhttp://www.sqlservercentral.com/Forums/Topic683866-146-1.aspxhi, In my database I created one table and add one column.column name is : column1 ..when i used select query select .select COLUMN1 FROM table ..it showing data.. how can i change the database to case sensitive..I am using sql server 2005 ctp expressedition..regards:giri...Thu, 26 Mar 2009 01:00:33 GMTdastagirid