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( ...
Get ADO.NET in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.