vb net option compare binary

Checking if two strings are equal

Comparing two strings for equality tin can be tricky. The result of var1 = var2 where Var1 and var2 only differ in the use of capitals depends on the Selection Compare Setting. This is risky business concern indeed. Setting Pick Compare is a module level decision effecting statement level results. If a module doesn't include an Option Compare statement, the default text comparison method is Binary (terms defined below):

"abc" = "ABC" » Imitation (Compare Binary)

Nonetheless, this is not e'er what ane wants. If for example in Excel one wants to bank check if a workbook with a sure proper name is open and then one wants

"MyWorkbook.xls" = "myworkbook.xls" » True (Compare text)

The way to ensure the required 'compare text' behavior is by using StrComp function as beneath.

(StrComp(Str1, Str2, vbTextCompare) = 0)

e.g.: (StrComp("abc", "ABC", vbTextCompare) = 0) » True

(StrComp("abc", "abc", vbTextCompare) = 0) » Truthful

(StrComp("abc", "ab", vbTextCompare) = 0) » False

Compare Binary results in string comparisons based on a sort order derived from the internal binary representations of the characters. In Microsoft Windows, sort club is determined past the code page. A typical binary sort order is shown in the post-obit example:

            A < B < East < Z < a < b < e < z < À < Ê < Ø < à < ê < ø

Compare Text results in cord comparisons based on a case-insensitive text sort social club determined by your organization's locale. When the same characters are sorted using Option Compare Text, the following text sort order is produced:

            (A=a) < (À= à) < (B=b) < (Due east=e) < (Ê= ê) < (Ø = ø) < (Z=z)

Option Compare Database tin can only exist used within Microsoft Admission. This results in string comparisons based on the sort social club determined by the locale ID of the database where the string comparisons occur.

            StrComp(              string1            ,                          string2            [,                          compare            ])

The StrComp function syntax has these named arguments:

Function	Clarification
*string1*	Required. Any valid string expression.
*string2*	Required. Any valid cord expression.
*compare*	Optional. Specifies the type of string comparison. If the *compare* argument is Null, an error occurs. If *compare* is omitted, the Selection Compare setting determines the type of comparison.

Abiding	Value	Clarification
vbUseCompareOption	-ane	Performs a comparison using the setting of the Option Compare statement.
vbBinaryCompare	0	Performs a binary comparison.
vbTextCompare	1	Performs a textual comparing.
vbDatabaseCompare	2	Microsoft Access only. Performs a comparison based on information in your database.

Return Values

The StrComp office has the post-obit return values:

If	StrComp returns
*string1* is less than *string2*	-i
*string1* is equal to *string2*	0
*string1* is greater than *string2*	i
*string1* or *string2* is Null	Null