Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

SQL file encoding in Visual Studio

Tags:

sql

visual-studio

stored-procedures

When we create stored procedures in Visual Studio (with the extension .sql) the file encoding is automatically set to 'Unicode (UTF-8 with signature) - Codepage 65001'.

This causes ours DBA's problems as their scripts don't like it.

We have to manually go in and change them to 'Western European (windows) - Codepage 1252'.

This only seems to be happening since we upgraded to VS 2008 from 2005. Can anyone explain whats going on and how to stop it?

like image 587
Simon Keep Avatar asked Sep 05 '08 08:09

Simon Keep

People also ask

How do I change the encoding of a file in Visual Studio?

From the File menu, choose Save File As, and then click the drop-down button next to the Save button. The Advanced Save Options dialog box is displayed. Under Encoding, select the encoding to use for the file.

How do I change the encoding of a SQL file?

Resave using correct encoding: File => Save As. Click the arrow next to the Save button. Choose the relevant encoding: Unicode (UTF-8 with asignature) - Codepage 65001.

How do I run a .SQL file in Visual Studio?

In Visual Studio Code, press Ctrl+Shift+P (or F1) to open the Command Palette. Select MS SQL:Connect and choose Enter.

2 Answers

To summarise the link provided by Codeslayer (in case the page url changes)...

Change the sql file templates to ANSI encoding by opening with notepad and then saving it as an ANSI file. You can do the same for files already created. \Common7\Tools\Templates\Database Project Items

You've just made our DBA's very happy!

like image 141
Simon Keep Avatar answered Oct 07 '22 02:10

Simon Keep

I think somebody faced a similar problem like yours and had the following workaround which is posted at

http://connect.microsoft.com/VisualStudio/feedback/Workaround.aspx?FeedbackID=319830

like image 34
Codeslayer Avatar answered Oct 07 '22 01:10

Codeslayer
Sign in to Comment

Related questions

Select rows by index in Amazon Athena
Use of 'REFERENCING NEW AS NEW OLD AS OLD ' while creating a trigger
How to order by letters then by numbers?
SQL Server Management Studio Logins Dialog missing
How to return the old value of a column in a postgres INSERT ON CONFLICT DO UPDATE?
ERROR 2005 (HY000): Unknown MySQL server host '[35.232.51.216]' (0) in google cloud SQL client
Reading SQL table in python
phpMy Admin 4.8.4 export table as SQL is missing
How can I return the result of a select in a function in MySQL?
How to remove special characters in column with MySQL?
strftim() in sqlite gives wrong results
Large (6 million rows) pandas df causes memory error with `to_sql ` when chunksize =100, but can easily save file of 100,000 with no chunksize
SQL query for distinct professors and courses
Use T-SQL window functions to retrieve 5-minute averages from 1-minute data
Multiple autoincrement ids based on table column
PostgreSQL group by without aggregate function. Why does it work?
Finding winner of each player group in a tournament - PostgreSQL
Pyspark: how to extract hour from timestamp
Where with OR condition for the same column in Rails
Update XML with an SQL query

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!