September 13, 2005 at 3:18 pm
Hi all,
I have created a new job with several steps. The last step is called "email log" which calls a mail.vbs script and puts a text read out in the body of the email. The email works but will only put the text in the body when it is saved as ANSI. When I set the job up in Enterprise Manager, I write to f:\mssql\log\bas_data_maint.txt file. By default, when this file is written to the directory it is saved there with UNICODE instead of ANSI. Where in SQLSERVER is this defined and if I change what reprecutions will I face.
Any and all help is greatly appreciated.
September 13, 2005 at 3:19 pm
I ran sp_helpsort and received the below information. Thought it might help.
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data
September 14, 2005 at 7:30 am
If you really need unicode, try to save as utf-8.
September 14, 2005 at 7:35 am
No, I don't need unicode. When the .txt file is written to the mssql\log\.txt file it automatically saves as UNICODE. I want it to automatically write to the file and save as ANSI
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply