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 | | | | |
  • 1
    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 '19 at 15:01
  • What version of SQL, what database collation, please provide sample DDL and the PowerShell code you're using. – HandyD Apr 18 '19 at 5:41
  • USE _DBA GO INSERT INTO DENNIS VALUES ('£') – Dennis Finke Apr 18 '19 at 8:06
  • Invoke-Sqlcmd -ServerInstance $TargetServerName -Database Master -InputFile $file.FullName -QueryTimeout 21600 – Dennis Finke Apr 18 '19 at 8:07
0

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, privacy policy and cookie policy

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