X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Normalize Unicode String In SQL Server, SQL Server 2008 R2    
post Oct 27 2019, 09:55 PM

Posts: 188
Joined: 27-January 18

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

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.
This post has been edited by mr.siro: Oct 27 2019, 09:57 PM
Go to the top of the page
post Oct 28 2019, 03:30 AM

Posts: 700
Joined: 26-May 15
From: The middle of Germany

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

A professional Access developer tool: Find and Replace for Access and VBA
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    2nd July 2020 - 01:44 PM