Query output is always in UNICODE... need ANSI ... Help?
From: MeesterJeem (junque_at_oqs.com)
Date: 11/25/04
- Next message: Jan van Veldhuizen: "common UPDATE syntax for SqlServer and Oracle"
- Previous message: jvb: "MSDE ACCESS UPSIZE"
- Messages sorted by: [ date ] [ thread ]
Date: 25 Nov 2004 09:27:16 -0800
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: Jan van Veldhuizen: "common UPDATE syntax for SqlServer and Oracle"
- Previous message: jvb: "MSDE ACCESS UPSIZE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
