SQL 2005 Managemet Studio ...Unicode?

9 Nov 2005 9:33 PM

Rich

Hello,

I was playing with SQL 2005 Management Studio and opened a proc for editing
then saved that file to my desktop. I noticed when I tried to open it in
notepad that the document had been saved as a Unicdoe encoded file. I was
wondering if there was a way to change this by default back to ANSI. Thanks.

Rich

10 Nov 2005 3:24 AM

Michael Cheng [MSFT]

Hi Rich,

To save the query in ANSI format, you could follow the steps below

1. Click menu File -> Save <current file name> As...
2. In the Dialog Box Save File As, click the little arrow on the right side
of Save, select "Save with Encoding..."
3. There will be a prompt Dialog "Advanced Save Options" for you to select
the encode.

For more information, you may check topic "Managing Files with Encoding" in
the Books Online. However, I am afraid you cannot set the default file
encoding.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

10 Nov 2005 11:01 AM

Tibor Karaszi

Strange, my machine has by default "Western European (Windows) - Codepage 1252". Makes me wonder
where the default is picked up from?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Michael Cheng [MSFT]" <v-min***@online.microsoft.com> wrote in message
news:T4CbVZa5FHA.1240@TK2MSFTNGXA02.phx.gbl...
> Hi Rich,
>
> To save the query in ANSI format, you could follow the steps below
>
> 1. Click menu File -> Save <current file name> As...
> 2. In the Dialog Box Save File As, click the little arrow on the right side
> of Save, select "Save with Encoding..."
> 3. There will be a prompt Dialog "Advanced Save Options" for you to select
> the encode.
>
> For more information, you may check topic "Managing Files with Encoding" in
> the Books Online. However, I am afraid you cannot set the default file
> encoding.
>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
>
> Sincerely yours,
>
> Michael Cheng
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>

11 Nov 2005 2:47 AM

Rich

That would be nice to know. I would like to change it.

Hello Tibor,

Show quote

> Strange, my machine has by default "Western European (Windows) -
> Codepage 1252". Makes me wonder where the default is picked up from?
>
> "Michael Cheng [MSFT]" <v-min***@online.microsoft.com> wrote in
> message news:T4CbVZa5FHA.1240@TK2MSFTNGXA02.phx.gbl...
>
>> Hi Rich,
>>
>> To save the query in ANSI format, you could follow the steps below
>>
>> 1. Click menu File -> Save <current file name> As...
>> 2. In the Dialog Box Save File As, click the little arrow on the
>> right side
>> of Save, select "Save with Encoding..."
>> 3. There will be a prompt Dialog "Advanced Save Options" for you to
>> select
>> the encode.
>> For more information, you may check topic "Managing Files with
>> Encoding" in the Books Online. However, I am afraid you cannot set
>> the default file encoding.
>>
>> Thank you for your patience and cooperation. If you have any
>> questions or concerns, don't hesitate to let me know. We are always
>> here to be of assistance!
>>
>> Sincerely yours,
>>
>> Michael Cheng
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader
>> so
>> that others may learn and benefit from your issue.
>> =====================================================
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.

11 Nov 2005 6:13 AM

Michael Cheng [MSFT]

Hi Tibor,

Good question!

I have made some research and find the default enconding is set according
to the settings in Regional and Language Options -> Advanced -> Language
for non-unicode programs.

If you select English (United Status), it will be "Western European
(Windows) - Codepage 1252".

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.