August 29, 2012 at 9:00 am
hello,
i want to change my serversql from case-sensitive to case non sensitive,someone can help me please.
thank you in advance.
August 30, 2012 at 1:56 am
http://msdn.microsoft.com/en-us/library/ms175835%28v=sql.90%29.aspx This should help
August 30, 2012 at 7:46 am
hello ,
i want to change the collation SQL_Latin1_General_CP1_CS_AS in Latin1_General_CI_AI
thank you
August 31, 2012 at 1:48 am
You will need to alter every column in every table to match the new collation, then alter every table, then alter the database
Or
Create a new DB with the right collation, create all the tables in the new DB then transfer the data
The article will help you complete what you need to do for point 1.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply