This “Binary Files Differ” error/message was annoying the heck out of me, but I had been able to fix it by checking out the the offending file, opening it in TEXTPAD and saving it as format PC / ANSI, then checking it back in.
Even this work-around, however, had failed to fix one file this past week so I had to dig further. I’ve finally located an answer / fix:
“Visual source safe doesn’t always recognize text file types properly. when checking-in files using ‘
auto‘ type — it treats them as binary.
“So when you compare two .sql files you might see ‘
binary files differ‘ — and nothing more. (that’s how vss treats binary files).
“The solution is to change the file type using the properties context menu for the file in source safe. Change the type to text, you should be able to perform the visual comparison. You can also click on the ‘advanced’ option when checking-in the file, and manually change the selection to ‘
“To avoid in the future – you can add file type settings under the options menu in visual source safe, to set the default behavior for various file types there.”