Powershell Invoke-Sqlcmd Replacing £ with?

Posted on

Question :

When I create a SQL Script that inserts the value ‘£’ or ‘€’ into a table the value on the table is a question mark (?)
Though, when I insert ‘$’ it inserts a dollar sign.

Anyone know what is going on and how to make sure a pound sign is inserted into the table?

Answer :

I managed to test that the text file may have been the issue. When I opened up the text file and changed the encoding to Unicode, the £ and the € were inserted into the databsase.

Leave a Reply

Your email address will not be published. Required fields are marked *