ADO.NET in a Nutshell

Name

SqlCompareOptions

Synopsis

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 http://www.unicode.org) 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

}

Hierarchy

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

Returned By

SqlString.SqlCompareOptions

Passed To

SqlString.{CompareOptionsFromSqlCompareOptions( ...