''SqlCompareOptions'' ''serializable, flag'

SqlCompareOptions serializable, flag

System.Data.SqlTypes (system.data.dll) enum

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


System.Object figs/U2192.gif System.ValueType figs/U2192.gif System.Enum(System.IComparable, System.IFormattable , System.IConvertible) figs/U2192.gif SqlCompareOptions

Returned By


Passed To

SqlString.{CompareOptionsFromSqlCompareOptions( ) , SqlString( )}

    Part I: ADO.NET Tutorial
    Part II: ADO.NET Core Classes
    Part III: API Quick Reference
    Chapter 34. The System.Data Namespace