Re: Query output is always in UNICODE... need ANSI ... Help?
From: Reg Besseling (regbes.nospam_at_hotmail.com)
Date: 11/30/04
- Next message: Jim L: "Universal Data Model"
- Previous message: Jim L: "Re: Isolating duplicates with unique key"
- In reply to: MeesterJeem: "Query output is always in UNICODE... need ANSI ... Help?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 30 Nov 2004 08:26:49 +0200
Meester,
Add the following to your list of parameters
@ansi_attachment = 'true'
Regards
Reg Besseling
"MeesterJeem" <junque@oqs.com> wrote in message
news:62ed6a02.0411250927.295e2ac9@posting.google.com...
> I'm using XP_Sendmail stored procedure to run a query and mail the
> results as an attachment in the resulting email. The process works
> fine except that the attachment (whatever.xyz) is apparently in
> UNICODE and the application that subsequently consumes the attachment
> (when double-clicked in the email)dislikes the UNICODE version of the
> attachment and rejects it. Using NOTEPAD to edit and save the
> unmodified attachment in ANSI format makes the application all happy
> and reads in the file OK.
>
> Q: Is there a way to tell SQL Server to output its results with ANSI
> coding rather than UNICODE? Perhaps there's a temporary option that
> can be set in the query?
- Next message: Jim L: "Universal Data Model"
- Previous message: Jim L: "Re: Isolating duplicates with unique key"
- In reply to: MeesterJeem: "Query output is always in UNICODE... need ANSI ... Help?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
