Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Microsoft SQL Server _ Normalize Unicode String In SQL Server

Posted by: mr.siro Oct 27 2019, 09:55 PM

Hello guys, i have search in internet, i don't find a way to do that. EX: https://stackoverflow.com/questions/7811976/normalize-unicode-string-in-SQL-server

QUOTE
Sorry, no, there is no such function in any version of SQL Server to date (2012 test builds). Comparisons can be correctly composition-insensitive, but there isn't a function to convert character composition usage to one normal form.
It has been suggested for a future version of the ANSI standard under the syntax NORMALIZE(string, NFC) but it's going to be a long time before this makes it to the real world. For now if you want to do normalisation you'll have to do it in a proper programming language with better string-handling capabilities, either by pulling the string out of the database or by writing a CLR stored procedure to do it.


I can normalize unicode with code in project, but if used this way, i must to check every control which can type unicode character by user. This is a hard task to do.
So, if you guys have a better way, please tell me.

Posted by: PhilS Oct 28 2019, 03:30 AM

For what purpose do you want to normalize the Unicode strings?