What normalization form does SQL Server use?

by Michael S. Kaplan, published on 2005/06/23 08:42 -04:00, original URI: http://blogs.msdn.com/b/michkap/archive/2005/06/23/431866.aspx


This question came up a few times at TechEd in Orlando, and recently it was asked again in the newsgroups by a guy named Tim:

Does SQL server allow input in both NFC and NFD? If so does it
normalize so a select on an NFC piece of text returns NFD and vice
versa? If normalized, is this at input or when the select is run - i.e.
does output form always match input form?

Any pointers to documentaion covering this will be much appreciated.

Not sure I would be so bold as to call this blog documentation, but one of my first blog posts talks about it a little -- Normalization and Microsoft -- what's the story?


no comments

Please consider a donation to keep this archive running, maintained and free of advertising.
Donate €20 or more to receive an offline copy of the whole archive including all images.

go to newer or older post, or back to index or month or day