whats the difference between Binary compare and Textual compare?
can anyone tell me?
thx
Printable View
whats the difference between Binary compare and Textual compare?
can anyone tell me?
thx
Not 100% sure, but I think the main difference is that textual isn't case sensitive.
Yep, i think you're right, this is straight out of the MSDN Library:
Quote:
Option Compare Binary results in string comparisons based on asort order derived from the internal binary representations of the characters. In Microsoft Windows, sort order is determined by the code page. A typical binary sort order is shown in the following example:
A < B < E < Z < a < b < e < z < À < Ê < Ø < à < ê < ø
Option Compare Text results in string comparisons based on a case-insensitive text sort order determined by your system'slocale. When the same characters are sorted using Option Compare Text, the following text sort order is produced:
(A=a) < ( À=à) < (B=b) < (E=e) < (Ê=ê) < (Z=z) < (Ø=ø)