michael_alawneh (7/28/2014)

---

I am running SQL Server 2012. I have been producing files as output for the Unix folks at work. We are running into an issue with what appears to be all the files I produce are using Unicode and placing hidden characters in the beginning of files. I am simply using "Results to File" as the option vs going to grid/text.

The data being exported is not in Unicode data types.

When viewed in UltraEdit hex mode I see "0" or "EF BB BF".

The solution I have been using to get around this is taking the file open it in Notepad and do a Save As with Encoding = ANSI from the dropdown.

Any help on just creating the file in ANSI from the get go would help.

Thanks.