Sample Header Ad - 728x90

A collation that ignores cedillas for comparison?

0 votes
1 answer
124 views
*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