Powershell Invoke-Sqlcmd Replacing £ with?

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?

Dennis Finke · 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.

Powershell Invoke-Sqlcmd Replacing £ with?

One Answer

Add your own answers!

Ask a Question