1

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?

Improve this question
4
  • 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
    Commented 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
    Commented Apr 18, 2019 at 5:41
  • USE _DBA GO INSERT INTO DENNIS VALUES ('£')
    – Dennis Finke
    Commented Apr 18, 2019 at 8:06
  • Invoke-Sqlcmd -ServerInstance $TargetServerName -Database Master -InputFile $file.FullName -QueryTimeout 21600
    – Dennis Finke
    Commented Apr 18, 2019 at 8:07

1 Answer 1

Reset to default
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.

Improve this answer

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.