Latin1_General_CI_AS vs SQL_Latin1_General_CP1_CI_AS

Duda existencial a la hora de elegir un diccionario en la instalación de un SQL

Latin1_General_CI_AS:

  • Latin1-General
  • Case-insensitive
  • Accent-sensitive
  • Kana type-insensitive
  • Width-insensitive


SQL_Latin1_General_CP1_CI_AS
:

  • Latin1-General
  • Case-insensitive
  • Accent-sensitive
  • Kana type-insensitive
  • Width-insensitive for Unicode Data
  • SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data