saving SQL files in SSMS as ASCII

6 May 2009 2:07 PM

Dan Holmes

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

6 May 2009 2:12 PM

Dan Holmes

Dan Holmes wrote:

> 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

i should have searched first. There is a connect on this already.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=354476&wa=wsignin1.0

6 May 2009 2:18 PM

Dan Holmes

Dan Holmes wrote:

> Dan Holmes wrote:
>> 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
> i should have searched first. There is a connect on this already.
>
> https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=354476&wa=wsignin1.0
>
>

I found another one.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=336750

i voted for it too!

7 May 2009 2:43 AM

Aaron Bertrand [SQL Server MVP]

There is also:

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=25977
9

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=32783
2

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=23488
8

Obviously some of these should be closed as duplicates.

On 5/6/09 10:18 AM, in article etsynWlzJHA.1***@TK2MSFTNGP06.phx.gbl, "Dan
Holmes" <dan.hol***@routematch.com> wrote:

Show quoteHide quote

> Dan Holmes wrote:
>> Dan Holmes wrote:
>>> 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
>> i should have searched first. There is a connect on this already.
>>
>> https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID
>> =354476&wa=wsignin1.0
>>
>>
> I found another one.
>
> https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=
> 336750
>
> i voted for it too!

7 May 2009 10:43 PM

Erland Sommarskog

Dan Holmes (dan.hol***@routematch.com) writes:

> 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?

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, esq***@sommarskog.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/prodinfo/previousversions/books.mspx