SQL SERVER – 2005 Collation Explanation and Translation – Part 2 | Journey to SQL Authority with Pinal Dave

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, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive Latin1_General_CI_AI_WS… Continue Reading...

Source: SQL SERVER – 2005 Collation Explanation and Translation – Part 2 | Journey to SQL Authority with Pinal Dave