SQL Collation Archives - Page 3 of 4 - SQL Authority with Pinal Dave

SQL SERVER – Find Collation of Database and Table Column Using T-SQL

December 16, 2008

Database, SQL Collation, SQL Scripts, SQL Server Management Studio

Today we will go over very quick tip about finding out collation of database and table column. Collations specify the rules for how strings of character data are sorted and compared, based on the norms of particular languages and locales Today’s script are self explanatory so I will not explain…

SQL Server – Good Articles on Database Collation

April 4, 2008

Pinal Dave

SQL

Database, DBA, SQL Collation, SQL Server

I often get asked what is Database Collation in SQL Server and if there are some good articles related to Collation. Here are some really interesting articles on this subject.

SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS

August 30, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Collation, SQL Scripts

This article is written based on feedback I have received on SQL SERVER – Cannot resolve collation conflict for equal to operation. Many reader asked me how to find collation of current database. There are two different ways to find out SQL Server database collation. 1) Using T-SQL (My Recommendation)…

SQL SERVER – 2005 Collation Explanation and Translation – Part 2

July 14, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Collation, SQL Scripts, SQL String

Following function return all the available collation of SQL Server 2005. My previous article about the SQL SERVER – 2005 Collation Explanation and Translation. SELECT * FROM sys.fn_HelpCollations() Result Set: (only few of 1011 records) Name Description Latin1_General_BIN Latin1-General, binary sort Latin1_General_BIN2 Latin1-General, binary code point comparison sort Latin1_General_CI_AI Latin1-General,…

SQL SERVER – Cannot Resolve Collation Conflict For Equal to Operation

June 11, 2007

Pinal Dave

SQL Tips and Tricks

Best Practices, SQL Collation, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server

Cannot resolve collation conflict for equal to operation. In MS SQL SERVER, the collation can be set at the column level.

SQL SERVER – Collate – Case Sensitive SQL Query Search

April 30, 2007

Pinal Dave

SQL Tips and Tricks

SQL Collation, SQL Scripts, SQL Search, SQL Server, SQL Utility

In this blog post we are going to learn about how to do Case Sensitive SQL Query Search.

If Column1 of Table1 has following values ‘CaseSearch, casesearch, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records.

SQL SERVER – 2005 Collation Explanation and Translation

April 24, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Collation

Just a day before one of our SQL SERVER 2005 needed Case-Sensitive Binary Collation. When we install SQL SERVER 2005 it gives options to select one of the many collation. I says in words like ‘Dictionary order, case-insensitive, uppercase preference’. I was confused for little while as I am used…