What are the differences between selecting Option Compare as binary or text? Does it affect performance?

MSDN Article at http://msdn.microsoft.com/en-us/libr...=vs.80%29.aspx

Hi there

Binary compare option, compares two string by their ASCII codes, so 'Test' is different to 'test' (so it is faster)
but Text compare, compares two string as 'ignore case', so 'Test' and 'test' are the same strings (So it may be slower than binary compare, but more useful in most cases). imagine you are searching some texts from Db, if binary search option is ON, so some good results may be ignored because of 'case sensitive compare'. binary compare is useful for cases that you're searching for exactly right typed word.

text compare maybe convert two strings to UpperCase and then compares them as binary.

__________________
happy every time, happy every where

Reza Baiat