SQL Server Change International to Roman characters

bxgwgixi 于 2023-04-28 发布在其他

关注(0)|答案(1)|浏览(108)

I have a string with International characters on it, like "Çiñoën Straße"

I need to code a function to change the string to a Roman version as "Cinoen Strabe"

I can follow a mapping approach, for example if 'Ç' is detected, replace it with 'C'

I wonder if there is a best approach, like using COLLATE

1条答案

this is more or less how it turned out
SET @output = REPLACE(@output COLLATE Latin1_General_Bin, 'ß', 'ss')

SET @output = REPLACE(REPLACE(@Output COLLATE Latin1_General_Bin, 'ç', 'c'), 'Ç', 'C')

Here it is the full list of European characters and their equivalent