SQL files are getting converted to binary files and not readable

[Chandra Sekhar Lattala]

Hi All,

This is to let you know that we are facing challenges to check in the SQL files. Once we check in the .sql files from local repository to remote repository. The files are getting converted to binary files in Bit Bucket and are not in a readable format.

Because of this, we are not able to compare the differences.

Please check and advise. Any help would really appreciated.

Thanks,

Chandra.

[Ankit Patel]

@Theodora Boudale 
From Today 24-09-2024 we cannot compare SQl files in VS Code.

Regards
Ankit

[Theodora Boudale]

Hi Ankit,

VS Code is built by Microsoft, it is not an Atlassian product. If you experience issues with VS Code, please reach out to the support team for that product:

• https://visualstudio.microsoft.com/support/

Kind regards,
Theodora

[Ankit Patel]

@Theodora Boudale 
 I am not talking about Vs code is also not visible in bitbucket in Atlassian view.its showing code in binary format.

[Theodora Boudale]

Hi Chandra and welcome to the community.

Do you know what encoding was used for these .sql files?

There is a bug with Bitbucket Cloud, UTF-16 and UTF-32 files do not show up in the diff:

• https://jira.atlassian.com/browse/BCLOUD-13930

If that's the case with your .sql files as well, then the diff is not rendering due to this bug.

Please feel free to let me know if you're using a different encoding for these files.

Kind regards,
Theodora