How to store unicode characters in SQL Server?

Question

In SQL Server, I am trying to create a table that can store unicode characters. Specifically this one

However if I pick nvarchar as the column type, then store it and then select it, it shows as a regular n.

How can I get it to store properly?

Make sure the column type is `NVARCHAR([length])` and if you are inserting strings, prefix them with `N'mystring'` so that it knows they're unicode. — EMUEVIL, Jun 26 '18 at 15:52

score 10 · Accepted Answer · answered Jun 26 '18 at 15:47

This works fine

DECLARE @t TABLE
(
InputChar NVARCHAR(10)
)

INSERT INTO @t (InputChar)
VALUES (N'ń')

INSERT INTO @t (InputChar)
VALUES ('ń')

SELECT * FROM @t

Are you making sure that when you inserting your strings you are specifying that the string is unicode ? e.g.N'yourstring'

1 Answers1