SQL Server Management Studio - Grid Result Save As .CSV - How to output Text instead of UTF-16 (Unicode)

sql-server csv unicode ssms utf-16

10,100

This answer applies if you're using Sql Server Management Studio for SQL 2005/2008.

On the "Save Results" form, the "Save" button has a small drop-down button at its right-hand end.

Click this and select "Save with Encoding". Select ANSI to get a single-byte character set.

10,100

craphunter

Solutions Architect at BeneSys, Inc LinkedIn | Twitter @GerhardWeiss Secretary at Great Lakes Area .NET Users Group (GANG) GANG LinkedIn Group | Meetings | Twitter @gangannounce I am a VB.NET and PL/B solutions and software architect, application designer, team leader, and senior programmer/analyst with 25 years of solid experience in all phases of software application development. I have had team leadership, project management, and mentoring responsibilities throughout the software development lifecycle. My experience has also included requirements gathering, analysis, database design, technical writing, testing, and deploying applications.

Updated on June 04, 2022

Comments

craphunter almost 2 years

In SQL Server Management Studio, can the Grid "Save As" be changed to write out an encoding that is Text instead of UTF-16?

When I right click a Result Grid in In SQL Server Management Studio, it allows for a Save As .CSV. Currently it saves the .CSV file encoded as UTF-16 (Unicode) but Excel does not open this format automatically (Excel prompts for a delimiter). To get around the prompt, I opened the file in SlickEdit and did a Save As "Text". Of course this is an extra step.
- Mark Ransom about 15 years
  
  I presume you're talking about SQL Server Management Studio? SQL Server itself doesn't have a UI.
- craphunter almost 15 years
  
  Mark. That would be correct. SQL Server Management Studio.