Is there a way to make SSMS default to US-ASCII when saving a .sql file? I have searched the options. Is that
connected to the current codepage of Windows?

dan

Dan Holmes wrote:

https://connect.microsoft.com/SQLSer...&wa=wsignin1.0

Dan Holmes wrote:

https://connect.microsoft.com/SQLSer...dbackID=336750

i voted for it too!

There is also:

http://connect.microsoft.com/SQL/fee...edbackID=25977
9

http://connect.microsoft.com/SQL/fee...edbackID=32783
2

http://connect.microsoft.com/SQL/fee...edbackID=23488
8

Obviously some of these should be closed as duplicates.




On 5/6/09 10:18 AM, in article etsynWlzJHA.1096 (AT) TK2MSFTNGP06 (DOT) phx.gbl, "Dan
Holmes" <dan.holmes (AT) routematch (DOT) com> wrote:

Dan Holmes (dan.holmes (AT) routematch (DOT) com) writes:
That one is a little difficult to grasp. I do get ANSI files when I save
from SSMS (which I don't do very often).

I think there is some auto-detecting going on, although I have not really
understood what it does.

In options, Text Editor, you can change the mapping for a file extension
so that it maps to "SQL Server Query with Encoding". Then you will be
prompted for encoding when you open a new window.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx