<div>
I did solve this with using a another way (sqlcmd.exe), thou did not solve the &quot;original Q&quot; on how to make invoke-sqlcms not escape special characters.<br />
<br />
I have not looked into YZlat solution.
</div>


I did solve this with using a another way (sqlcmd.exe), thou did not solve the "original Q" on how to make invoke-sqlcms not escape special characters.

I have not looked into YZlat solution.

<div>
<div class="content wysiwyg-content">
I have a problem when invoking sql scripts with the use of invoke-sqlcmd.<br />
<br />
Every spesial character i use (like Æ, Ø and Å) are being replaced with a ?.<br />
<br />
This does not happen when i manualy load these scripts in management studio.<br />
<br />
SQL server 2008<br />
Powershell 2.0<br />
<br />
My code to run the scripts<br />
<br />

<pre><code id="code-10-27587789-1">invoke-sqlcmd -InputFile $create_clean -ServerInstance $sql_server -database $dbname -ErrorAction &quot;silentlycontinue&quot;</code></pre>
<br />
Here is a dude with the exact same problem!<br />
<br />
<a href="http://www.sqlservercentral.com/Forums/Topic1159860-1351-1.aspx" rel="ugc">http://www.sqlservercentral.com/Forums/Topic1159860-1351-1.aspx</a><br />
<br />
<br />
Please help!!
</div>
</div>


I have a problem when invoking sql scripts with the use of invoke-sqlcmd.

Every spesial character i use (like Æ, Ø and Å) are being replaced with a ?.

This does not happen when i manualy load these scripts in management studio.

SQL server 2008
Powershell 2.0

My code to run the scripts

(CODE)

Here is a dude with the exact same problem!

http://www.sqlservercentral.com/Forums/Topic1159860-1351-1.aspx


Please help!!

Invoke-sqlcmd problem - special characters replaced with &quot;?&quot;

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Invoke-sqlcmd problem - special characters replaced with &quot;?&quot;

Invoke-sqlcmd problem - special characters replaced with "?"