Specifies how SqlString instances are compared. You can use any bitwise combination of these values. BinarySort specifies that sorts should be based on the character’s numeric value, rather than its alphabetic value. IgnoreCase specifies that SqlString comparison won’t take capitalization into account. The other values apply primarily to extended character sets. For example, IgnoreKanaType specifies that SqlString comparisons must ignore the Kana type (the Kana type refers to Japanese hiragana and katakana characters, which represent phonetic sounds in the Japanese language). IgnoreNonSpace specifies that SqlString comparisons must ignore nonspace combining characters, such as diacritics. The Unicode Standard (see defines combining characters as characters that are combined with base characters to produce a new character. Finally, IgnoreWidth specifies that SqlString comparisons must ignore the character width (which can apply to languages such as Japanese where some characters can be written an full or half width).

public enum SqlCompareOptions {

   None = 0x00000000,

   IgnoreCase = 0x00000001,

   IgnoreNonSpace = 0x00000002,

   IgnoreKanaType = 0x00000008,

   IgnoreWidth = 0x00000010,

   BinarySort = 0x00008000



System.Object System.ValueType System.Enum(System.IComparable, System.IFormattable, System.IConvertible) SqlCompareOptions

Returned By


Passed To

SqlString.{CompareOptionsFromSqlCompareOptions( ...

Get ADO.NET in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.