TEXT COMPARE CODE

TEXT COMPARE CODE

When the same characters in the same code page are sorted by using Option Compare Text, the following text sort order is produced. In the following example, characters in the English/European code page (ANSI 1252) are sorted by using Option Compare Binary, which produces a typical binary sort order.Ī < B < E < Z < a < b < e < z < À < Ê < Ø < à < ê < ø In Microsoft Windows, sort order is determined by the code page.

A Text comparison compares each Unicode character based on its lexical meaning in the current culture. The default text comparison method is Binary.Ī Binary comparison compares the numeric Unicode value of each character in each string. The Option Compare statement specifies the string comparison method ( Binary or Text). If used, the Option Compare statement must appear in a file before any other source code statements. For example, you might want to consider A and a to be equal, and Ä and ä to come before B and b. This type of comparison is useful if your strings contain all text characters, and you want to compare them taking into account alphabetic equivalences such as case insensitivity and closely related letters. Results in string comparisons based on a case-insensitive text sort order determined by your system's locale. In this case, you do not want to bias comparisons with alphabetical equivalences, such as case insensitivity. This type of comparison is useful especially if the strings can contain characters that are not to be interpreted as text. Results in string comparisons based on a sort order derived from the internal binary representations of the characters. Declares the default comparison method to use when comparing string data.

Text compare