Windows Azure SQL Database Encoding

Question

How to change the sorting of an Azure SQL database? I need to change it to Latin1_General_CI_AS

Thanks!

Answer 1

SQL Azure v12 supports changing the sorting of data in a database. However, directory mapping is fixed and cannot be changed.

Answer 2

You cannot change the sorting of the Azure SQL database at the server level: http://msdn.microsoft.com/en-us/library/windowsazure/ee336245.aspx#sscs

You can change it when creating the database initially.

Answer 3

.

1)

2)

3)

4) SSMS, . , .

5)

. CI CS.

.

, cmd .

SELECT c.name, c.collation_name FROM SYS.COLUMNS c JOIN SYS.TABLES t ON t.object_id = c.object_id

. ; , . , .