Contents
How does collation work in a SQL Server?
Basically what’s going on here is that each database has its own collation which “provides sorting rules, case, and accent sensitivity properties for your data” (from http://technet.microsoft.com/en-us/library/ms143726.aspx) and applies to columns with textual data types, e.g. VARCHAR, CHAR, NVARCHAR, etc.
How to resolve collation conflict between two databases?
Cannot resolve the collation conflict between “SQL_Latin1_General_CP850_CI_AI” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. sql-servertsqlcollation Share Improve this question
How to do a join across two databases?
It’s also useful for temp table and table variables, and where you may not know the server collation (eg you are a vendor placing your system on the customer’s server) select sone_field collate DATABASE_DEFAULT from table_1 inner join table_2 on table_1.field collate DATABASE_DEFAULT = table_2.field where whatever
How to use the collate clause in a query?
You can use the collate clause in a query (I can’t find my example right now, so my syntax is probably wrong – I hope it points you in the right direction) select sone_field collate SQL_Latin1_General_CP850_CI_AI from table_1 inner join table_2 on (table_1.field collate SQL_Latin1_General_CP850_CI_AI = table_2.field) where whatever
How are windows collations used for Unicode sorting?
Windows collations. For a Windows collation, comparison of non-Unicode data is implemented by using the same algorithm as Unicode data. The base Windows collation rules specify which alphabet or language is used when dictionary sorting is applied, and the code page that is used to store non-Unicode character data.
When to use case insensitive collation in SQL Server?
If selected, lowercase letters sort ahead of their uppercase versions. If this option is not selected, the collation is case-insensitive. That is, SQL Server considers the uppercase and lowercase versions of letters to be identical for sorting purposes. You can explicitly select case insensitivity by specifying _CI.
Are there binary collations for Unicode data types?
For binary collations on Unicode data types, the locale is not considered in data sorts. For example, Latin_1_General_BIN and Japanese_BIN yield identical sorting results when they are used on Unicode data. There are two types of binary collations in SQL Server; the older BIN collations and the newer BIN2 collations.