Visual Studio中的SQL文件编码 [英] SQL file encoding in Visual Studio

问题描述

当我们在Visual Studio中创建存储过程(扩展名为.sql)时，文件编码会自动设置为"Unicode(带签名的UTF-8)-代码页65001".

When we create stored procedures in Visual Studio (with the extension .sql) the file encoding is automatically set to 'Unicode (UTF-8 with signature) - Codepage 65001'.

这会导致我们DBA的问题，因为他们的脚本不喜欢它.

This causes ours DBA's problems as their scripts don't like it.

我们必须手动进入并将其更改为西欧(windows)-代码页1252".

We have to manually go in and change them to 'Western European (windows) - Codepage 1252'.

这似乎只是自我们从2005年升级到VS 2008以来发生的事情.任何人都可以解释发生了什么事以及如何阻止它吗?

This only seems to be happening since we upgraded to VS 2008 from 2005. Can anyone explain whats going on and how to stop it?

推荐答案

我认为有人遇到了与您类似的问题，并且有以下变通办法发布于

I think somebody faced a similar problem like yours and had the following workaround which is posted at

http://connect.microsoft.com/VisualStudio/feedback/Workaround.aspx?FeedbackID=319830

这篇关于Visual Studio中的SQL文件编码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！