How to save the currency symbol correctly for Philippine Peso in sql

  Kiến thức lập trình

I have a table where I am storing the currency and their symbols when it comes to Philippine Peso ₱ it is not storing correctly

CREATE TABLE currency (
  country  VARCHAR(100),
  currency VARCHAR(100),
  code     VARCHAR(100),
  symbol   nVARCHAR(100)
);

INSERT INTO currency (country, currency, code, symbol) VALUES ('Cuba', 'Pesos', 'CUP', '₱');

When I tried for the UNICODE and conversion this gives me the same

SELECT UNICODE('₱');
SELECT NCHAR(63);

enter image description here

How can I store all the symbols correctly in to the table with out any issues

  • sql-server

1

LEAVE A COMMENT