Export (0) Print
Expand All
Expand Minimize

SqlCompareOptions Enumeration

Specifies the compare option values for a SqlString structure.

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

Namespace:  System.Data.SqlTypes
Assembly:  System.Data (in System.Data.dll)

[SerializableAttribute]
[FlagsAttribute]
public enum SqlCompareOptions

Member nameDescription
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkNoneSpecifies the default option settings for SqlString comparisons.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkIgnoreCaseSpecifies that SqlString comparisons must ignore case.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkIgnoreNonSpaceSpecifies that SqlString comparisons must ignore nonspace combining characters, such as diacritics. The Unicode Standard defines combining characters as characters that are combined with base characters to produce a new character. Non-space combining characters do not use character space by themselves when rendered. For more information about non-space combining characters, see the Unicode Standard at http://www.unicode.org.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkIgnoreKanaTypeSpecifies that SqlString comparisons must ignore the Kana type. Kana type refers to Japanese hiragana and katakana characters that represent phonetic sounds in the Japanese language. Hiragana is used for native Japanese expressions and words, while katakana is used for words borrowed from other languages, such as "computer" or "Internet". A phonetic sound can be expressed in both hiragana and katakana. If this value is selected, the hiragana character for one sound is considered equal to the katakana character for the same sound.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkIgnoreWidthSpecifies that SqlString comparisons must ignore the character width. For example, Japanese katakana characters can be written as full-width or half-width and, if this value is selected, the katakana characters written as full-width are considered equal to the same characters written in half-width.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkBinarySortSpecifies that sorts should be based on a characters numeric value instead of its alphabetical value.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkBinarySort2Performs a binary sort.

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98, Windows CE, Windows Mobile for Smartphone, Windows Mobile for Pocket PC, Xbox 360, Zune

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5, 3.0, 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 3.5, 2.0, 1.0

XNA Framework

Supported in: 3.0, 2.0, 1.0

Community Additions

ADD
Show:
© 2014 Microsoft