If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Thanks. It's the data comparison difference that has me concerned. If the only problem will be with Binary "John Doe" does NOT equal "JOHN DOE" and after changing the collation "John Doe" does equal "JOHN DOE" that's ok because we want to have a match in this situation. But I can't think of examples where case sensitive comparisons may be necessary. I've warned the business users they may see a difference in sorting, but I'm not sure what other warnings to provide outside of a possible dip in performance during large search operations.