*Cedillas* are mutations applied to letters in some languages, like portuguese, french, turkish and romanian. Some words: "coração", "açúcar", "linhaça" (letters 'Ç', 'Ş', ...).
How to choose a collation that ignores *cedillas* for comparison? They are not accents.
[This blog post](https://sqlfromhell.wordpress.com/2010/05/01/ignorando-letras-maiusculas-minusculas-acentos-e-c/) (in portuguese) teaches that:
*
SQL_Latin1_General_CP1_CI_AI
: considers *cedillas*
* Latin1_General_CI_AI
: ignores *cedillas*
What is the difference? It's not clear in the name of the collation.
Asked by Alexandre
(103 rep)
Nov 23, 2024, 12:00 AM
Last activity: Dec 20, 2024, 11:49 AM
Last activity: Dec 20, 2024, 11:49 AM