For example, when you construct a query by using ORDER BY, the sort order of your result set might depend on the collation that's applied to the database or dictated in a COLLATE clause at the expression level of the query. These characteristics affect the results of many operations in the database. When you select a collation for your server, database, column, or expression, you're assigning certain characteristics to your data. To list the collations that are available on your instance of SQL Server, see sys.fn_helpcollations (Transact-SQL). Whether you're installing a new instance of SQL Server, restoring a database backup, or connecting server to client databases, it's important to understand the locale requirements, sorting order, and case and accent sensitivity of the data that you're working with. Collations that are used with character data types, such as char and varchar, dictate the code page and corresponding characters that can be represented for that data type. Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL Endpoint in Microsoft Fabric Warehouse in Microsoft FabricĬollations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |