TransWikia.com

Powershell Invoke-Sqlcmd Replacing £ with?

Database Administrators Asked by Dennis Finke on December 24, 2021

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?

One 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.

Answered by Dennis Finke on December 24, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP