What does collation mean?

by

Collation can be simply thought of as sort order.

In English (and it’s strange cousin, American), collation may be a pretty simple matter consisting of ordering by the ASCII code.

Once you get into those strange European languages with all their accents and other features, collation changes. For example, though the different accented forms of a may exist at disparate code points, they may all need to be sorted as if they were the same letter.

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. How can I do an UPDATE statement with JOIN in SQL Server?
  3. How important is the order of columns in indexes?
  4. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  5. Convert Xml to Table SQL Server
  6. SQL Server : Transpose rows to columns
  7. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  8. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  9. Is it possible to select sql server data using column ordinal position
  10. How do I group on continuous ranges
  11. How can a LEFT OUTER JOIN return more records than exist in the left table?
  12. What’s the best to check if item exist or not: Select Count(ID)OR Exist(…)?
  13. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  14. Dynamic SQL to generate column names?
  15. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  16. Extracting hours from a DateTime (SQL Server 2005)
  17. Column name or number of supplied values does not match table definition
  18. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  19. How to split string using delimiter char using T-SQL?
  20. How to find consecutive rows based on the value of a column?
  21. How to escape square brackets inside square brackets for field name
  22. How do you copy a record in a SQL table but swap out the unique id of the new row?
  23. Average of multiple columns
  24. Eliminate and reduce overlapping date ranges
  25. Cumulative Total in MS Sql server [duplicate]
  26. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  27. Memory effective way to read BLOB data in C#/SQL 2005
  28. Distributed transaction error?
  29. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?
  30. Determine what user created objects in SQL Server

Leave a Comment