troubleshooting Question

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

Avatar of frankEQS
frankEQS asked on
PowershellMicrosoft SQL Server 2008
3 Comments2 Solutions3141 ViewsLast Modified:
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

invoke-sqlcmd -InputFile $create_clean -ServerInstance $sql_server -database $dbname -ErrorAction "silentlycontinue"

Here is a dude with the exact same problem!

http://www.sqlservercentral.com/Forums/Topic1159860-1351-1.aspx


Please help!!
ASKER CERTIFIED SOLUTION
frankEQS

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros