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?

  • 2
    It's an effect caused by Brexit - the system is unsure if the British are going to remain in the EU or not!
    – Vérace
    Apr 17, 2019 at 15:01
  • What version of SQL, what database collation, please provide sample DDL and the PowerShell code you're using.
    – HandyD
    Apr 18, 2019 at 5:41
  • USE _DBA GO INSERT INTO DENNIS VALUES ('£') Apr 18, 2019 at 8:06
  • Invoke-Sqlcmd -ServerInstance $TargetServerName -Database Master -InputFile $file.FullName -QueryTimeout 21600 Apr 18, 2019 at 8:07

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.