Query analyser unicode wonder.(sql 2005)

microsoft.public.dotnet.framework.adonet

7 Feb 2006 7:14 PM

jens Jensen

Hello,
It is possible to configure query analyser to output the result of a query
to a file.
The problem is that the file is saved with with unicode chars.
I want my file to be ANSI . How can i do this?

Many thanks in advance
JJ

8 Feb 2006 3:40 AM

Val Mazur (MVP)

Hi JJ,

You configure output to file when you select Query/Results To File .. menu
option in a QA. When you run query and QA asks you for the output file name,
then in a File Name you could choose encoding of the output - Unicode or ANSI

--
Val Mazur
Microsoft MVP
http://xport.mvps.org

Show quote

"jens Jensen" wrote:

>
> Hello,
> It is possible to configure query analyser to output the result of a query
> to a file.
> The problem is that the file is saved with with unicode chars.
> I want my file to be ANSI . How can i do this?
>
> Many thanks in advance
> JJ
>
>
>

8 Feb 2006 8:06 AM

jens Jensen

Thanks,
but the file save dialog does not allow this as opposed to in other cases.
It is simply not an option.