UtterAccess.com
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    
 
   
mr.siro
post Oct 27 2019, 09:55 PM
Post#1



Posts: 186
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

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



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


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

--------------------
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    15th December 2019 - 01:14 PM