I use Powershell to deploy DB scripts. In one script file, I have French accented characters.
When I call Invoke-sqlcmd and pass the script to the -inputfile, the French characters get mangled.
In the bad old days, the workaround was to save the files as unicode, and sqlcmd would handle them OK.
How do I go about this in this brave new world?