You can I display special Unicode characters in my result set on my SQL Server?
e.g. How can i display those characters ☺♦♦?
You can I display special Unicode characters in my result set on my SQL Server?
e.g. How can i display those characters ☺♦♦?
 
                        
Well due to the fact that your question is very unspecific here are some solutions.
You need to specify a string as unicode string. This can be achieved by adding an
Nin front of the string. See example:Result:
If you want to store those symbols, you need a type as
nvarcharornchar.Hopefully this helps you.