Inserting special characters (greater/less than or equal symbol) into SQL Server database

Question

I am trying to insert ≤ and ≥ into a symbol table where the column is of type nvarchar.

Is this possible or are these symbols not allowed in SQL Server?

Answer 1

To make it work, prefix the string with N

create table symboltable 
(
  val nvarchar(10)
)

insert into symboltable values(N'≥') 

select *
from symboltable 

Further Reading:

• You must precede all Unicode strings with a prefix N when you deal with Unicode string constants in SQL Server
• Why do some SQL strings have an 'N' prefix?