source tree 对 sql 文件 git 不能预览比较的问题

原因是因为 sql 文件编码的问题。不累述，见  https://jira.atlassian.com/browse/SRCTREEWIN-5485 里的解释。

 

解决方式

Found a solution that makes it work for ST

Put this inside your .gitconfig Either globally in $HOME/.gitconfig or in your repository $REPO/.git/config

[diff "sql"] 
    textconv = "iconv -f utf-16 -t utf-8"

Then just put the following in .gitattributes

*.sql diff=sql

Works with ST and the MINGW64 console. 

Note: This will not work from cmd! If needed it might be doable by creating a different difftool I guess. But don't really care for cmd right now.