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.
Quick thought, use the bcp Utility to export the data.
😎