Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

put sql in bitbucket but treats it as binary so pull requests do not show diffs

Joel Sciandra October 5, 2022

trying to put sql in bitbucket but it wants to treat it as binary so pull requests do not show diffs. I know that gitattributes solves this on the local side but not bitbucket. Any solutions?

1 answer

1 accepted

2 votes
Answer accepted
Joel Sciandra October 5, 2022

when you export sql files from MS SQL Server Management Studio in unicode (by default), it puts a "FF FE BOM" at the front of the file which forces bitbucket to treat it as binary. Exporting as ANSI solved it.

Onur Barlık
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 9, 2024

Thanks, saving with UTF-8 (without BOM) solves that issue too. But this is a only a workaround.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events