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