Click here to Skip to main content
15,891,778 members
Articles / Database Development / SQL Server / SQL Server 2008

Configuring SQL Server Accent-Insensitivity

Rate me:
Please Sign up or sign in to vote.
5.00/5 (9 votes)
21 Feb 2012CPOL7 min read 57.9K   389   9  
This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.
using System;

namespace Siphon
{
    public class ScriptEventArgs : EventArgs
    {
        public Int32 ProgressValue { get; set; }
        public Int32 ProgressMaximum { get; set; }
        public String Status { get; set; }

        public ScriptEventArgs(Int32 value, Int32 maximum, String status)
        {
            ProgressMaximum = maximum;
            ProgressValue = value;
            Status = status;
        }
    }

    public delegate void ScriptEventHandler(ScriptEventArgs args);
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Chief Technology Officer Shift iQ
Canada Canada
I have been building software systems for more than 20 years, working for organizations that range from small non-profit associations in my local community to global Fortune 500 enterprises.

I specialize in the design and implementation of online database solutions. My work-related research interests include software design patterns and information architecture.

Comments and Discussions