![]() The char, varchar, text, nchar, nvarchar, or ntext system data types, and all user-defined data types based on these system data types, are changed to the new default collation. When you change the database collation, you change:Īny char, varchar, text, nchar, nvarchar, or ntext columns in system tables are changed to the new collation.Īll existing char, varchar, text, nchar, nvarchar, or ntext parameters and scalar return values for stored procedures and user-defined functions are changed to the new collation. You can find the supported collation names in Windows Collation Name (Transact-SQL) and SQL Server Collation Name (Transact-SQL) or you can use the sys.fn_helpcollations (Transact-SQL) system function. The ALTER DATABASE COLLATE statement is not supported on Azure SQL Database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |