SS2005 Mngmnt Studio - how to disable / "turn off" UNICODE??

20 Feb 2007 10:59 PM

j.a. harriman

Hi,
I never had this issue in the "text" results pane of SQL Server 200, but
when I save the "text" results in SS2005, the results end up with UNICODE
encoding.

I then have to open the file in Notepad, do a "File->Save As", changing the
"Encoding" option to ASCII, then save the file.

This is simply inexcusable and intolerable as an option.

I'm sure I missed some setting (I hope).

Thanks.

20 Feb 2007 11:24 PM

Erland Sommarskog

j.a. harriman (jeffrey_no_spam_alias@nospam.nospam) writes:

> I never had this issue in the "text" results pane of SQL Server 200, but
> when I save the "text" results in SS2005, the results end up with UNICODE
> encoding.
>
> I then have to open the file in Notepad, do a "File->Save As", changing
> the "Encoding" option to ASCII, then save the file.

In the Save dialog, there is an arrow on the right. There you can pick
"Select with encoding" to make a choice on how to save the file.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

20 Feb 2007 11:45 PM

j.a. harriman

Erland,

Yes, I see on the "Save" button there is a drop-down arrow that has two
choices:
1.) Save
2.) Save With Encoding (UNICODE, ANSI, or Chinese)

Isn't there a default setting somewhere in Management Studio (registry?!) so
that I can set the default to ANSI instead of UNICODE?

Thanks.

Show quote

"Erland Sommarskog" wrote:

> j.a. harriman (jeffrey_no_spam_alias@nospam.nospam) writes:
> > I never had this issue in the "text" results pane of SQL Server 200, but
> > when I save the "text" results in SS2005, the results end up with UNICODE
> > encoding.
> >
> > I then have to open the file in Notepad, do a "File->Save As", changing
> > the "Encoding" option to ASCII, then save the file.
>
> In the Save dialog, there is an arrow on the right. There you can pick
> "Select with encoding" to make a choice on how to save the file.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>

2 Mar 2007 7:11 PM

Aaron Bertrand [SQL Server MVP]

> Yes, I see on the "Save" button there is a drop-down arrow that has two
> choices:
> 1.) Save
> 2.) Save With Encoding (UNICODE, ANSI, or Chinese)
>
> Isn't there a default setting somewhere in Management Studio (registry?!)
> so
> that I can set the default to ANSI instead of UNICODE?

Not yet, but if you want it, you can vote for it:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=259779

--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006