|
|
|
Raw
|
The AVM compares the two strings using the numeric values in the
current code page.
|
|
|
|
Case-Sensitive
|
The AVM performs a case-sensitive comparison of the two strings
using the numeric values in either the collation table specified in
collation, or the collation table of the client. If you specify this
strength with an ICU collation, the AVM applies the ICU TERTIARY strength.
|
|
|
|
Case-Insensitive
|
The AVM performs a case-insensitive comparison of the two strings
using the numeric values in either the collation table specified in
collation, or the collation table of the client. If you specify this
strength with an ICU collation, the AVM applies the ICU SECONDARY strength.
|
|
|
|
Caps
|
The AVM converts any lowercase letters in the two strings to uppercase
letters, based on the settings of the Internal Code Page (-cpinternal)
and Case Table (-cpcase) startup parameters, and then performs a raw
comparison of the resulting strings. When neither string contains a
wildcard character, this option behaves the same as the MATCHES operator.
|
|
|
|
Primary
|
The AVM compares the base characters in the two strings.
|
|
|
|
Secondary
|
The AVM compares the base characters and any diacritical marks in
the two strings.
|
|
|
|
Tertiary
|
The AVM performs a case-sensitive comparison of the base characters
and diacritical marks in the two strings.
|
|
|
|
Quarternary
|
The AVM performs a case-sensitive comparison of the base characters
and any diacritical marks in the two strings, and distinguishes words
with and without punctuation. ICU uses this strength to distinguish
between Hiragana and Katakana when applied with the ICU-JA (Japanese)
collation. Otherwise, it is the same as TERTIARY.
|
