Mgmt Studio save results as issue

Question

I have a SQL query that returns 1 column. I run it in SQL Server Management Studio 2008R2. I use File\Save Grid Results and create a .TXT file.

My problem is the first record of the file has 3 bytes inserted in front of the data. They three bytes are x'EFBBBF'. This causes problem when I use the file in another process.

I get the same thing wheter I save as .TXT or as .CSV.

Any ideas?

Answer 1

Found it.

1. Save Results As...
2. Choose a folder
3. Enter a file name
4. Save button now has a dropdown arrow to the right
5. Click on dropdown arrow and select Save with Encoding...
6. Select ANSI
7. Click OK

The ANSI-encoded file will not contain a UTF-8 BOM.