Export (0) Print
Expand All

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.

[Visual Basic]
<Flags>
<Serializable>
Public Enum SqlCompareOptions
[C#]
[Flags]
[Serializable]
public enum SqlCompareOptions
[C++]
[Flags]
[Serializable]
__value public enum SqlCompareOptions
[JScript]
public
   Flags
 Serializable
enum SqlCompareOptions

Members

Member name Description Value
BinarySort

Supported by the .NET Compact Framework.

Specifies that sorts should be based on a characters numeric value rather than its alphabetic value. 32768
IgnoreCase

Supported by the .NET Compact Framework.

Specifies that SqlString comparisons must ignore case. 1
IgnoreKanaType

Supported by the .NET Compact Framework.

Specifies that SqlString comparisons must ignore the Kana type. Kana type refers to Japanese hiragana and katakana characters, which 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. 8
IgnoreNonSpace

Supported by the .NET Compact Framework.

Specifies 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 take up character space by themselves when rendered. For more information on non-space combining characters, see the Unicode Standard at http://www.unicode.org . 2
IgnoreWidth

Supported by the .NET Compact Framework.

Specifies 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. 16
None

Supported by the .NET Compact Framework.

Specifies the default option settings for SqlString comparisons. 0

Requirements

Namespace: System.Data.SqlTypes

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, .NET Compact Framework

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

See Also

System.Data.SqlTypes Namespace

Show:
© 2014 Microsoft