sql Server中是否有一个函数来规范化unicode字符串？例如
UPDATE Orders SET Notes = NormalizeString(Notes,'FormC')
Unicode规范化表单：
> C omposition(C)：A¨成为Ä
>分解(D)：Ä变为A¨
>兼容成分(KC)：A – fi n成为Äfin
>兼容分解(KD)：Äfi n变为A¨fi n
我找不到任何内置函数,所以我假设没有.
理想情况下,如果只有一个,那么我今天碰巧需要表格C：
Unicode normalization form C,canonical composition. Transforms each decomposed grouping,consisting of a base character plus combining characters,to the canonical precomposed equivalent. For example,A + ¨ becomes Ä.
也可以看看
> Unicode Normalization in Windows
> How do I remove diacritics (accents) from a string in .NET?
> NormalizeString function
> Sorting it all out: What normalization form does SQL Server use
