November 26, 2003 at 9:42 am
SQL Mail appears to generate a text file in unicode format by default. Is there a way to output in ANSI ?
Thanks
November 26, 2003 at 10:33 am
Shouldn't be unicode. Is your server setup for Unicode? What code are you running to get the Unicode results?
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
November 26, 2003 at 11:10 am
Here is what's happening. SQL Mail sends out the query results as a text file. Now if we try to save this file with .csv extension, and open in excel, it does not work. But when we save it as .csv and select the ansi format, it works. How can we automate the process ?
quote:
Shouldn't be unicode. Is your server setup for Unicode? What code are you running to get the Unicode results?Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply