SQL collation is important because it sets linguistic rules for comparing strings and sorting text values without requiring explicit case-insensitive comparison or sorting rules like in programming languages.
SQL Server has collations for most world languages and allows for turning on/off case, accent, or Kana sensitivity rules. Using collations can save time when fixing language-specific sorting bugs, making it beneficial for global market applications.