SqlCompareOptions 列舉

定義

指定 SqlString 結構的比較選項。Specifies the compare option values for a SqlString structure.

此列舉具有 FlagsAttribute 個屬性允許以位元方式合併其成員值。

public enum class SqlCompareOptions
[System.Flags]
[System.Serializable]
public enum SqlCompareOptions
type SqlCompareOptions = 
Public Enum SqlCompareOptions
繼承
SqlCompareOptions
屬性

欄位

BinarySort 32768

指定排序應該根據字元數值,而非其字母順序值。Specifies that sorts should be based on a characters numeric value instead of its alphabetical value.

BinarySort2 16384

執行二進位編碼排序。Performs a binary sort.

IgnoreCase 1

指定 SqlString 比較必須忽略大小寫。Specifies that SqlString comparisons must ignore case.

IgnoreKanaType 8

指定 SqlString 比較必須忽略假名類型。Specifies 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. 平假名用於本土日文的語句和字詞,而片假名則用於自其他語言引進的字詞,例如「computer」或「Internet」。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.

IgnoreNonSpace 2

指定 SqlString 比較必須忽略非空格組成的字元,例如變音符號 (Diacritic)。Specifies that SqlString comparisons must ignore nonspace combining characters, such as diacritics. Unicode Standard 將組合的字元定義為與基底字元結合以產生新字元的字元。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. 如需非空格組合字元的詳細資訊,請參閱 https://www.unicode.org 的<Unicode 標準>。For more information about non-space combining characters, see the Unicode Standard at https://www.unicode.org.

IgnoreWidth 16

指定 SqlString 比較必須忽略字元寬度。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.

None 0

指定 SqlString 比較的預設選項設定值。Specifies the default option settings for SqlString comparisons.

適用於