a6koxq
Last Updated: February 25, 2016
·
6.858K
· dominicgoulet
F46b59cda547441decd60fe1f6240f93

How to remove diacritics in SQL Server

The easiest way to remove diacritics from a string in SQL Server is to collate the string using a character set that does not include diacritics, such as :

SELECT 'àéêöhello!' Collate SQL_Latin1_General_CP1253_CI_AI

This will output :

aeeohello!

This work only if you are not using a unicode string, so cast it as varchar first if you have a unicode string.

Say Thanks
Respond