What is UNICODE Character in Sql server

Handling multiple languages specific character within a single database is difficult to manage. It is also difficult to translate language specific data or special character in a correct format without using any code page (template). Now on days database use to support worldwide clients (local and international) and it’s advisable always to use Unicode data ...

What is Difference between nchar and nvarchar

nchar and nvarchar are indicates that it will store Unicode characters whereas char and varchar can’t store Unicode characters. Char and nchar are fixed-length datatype. Fixed-length datatype that means it will occupy space whatever number you have specified at the time of table definition. Even if you don’t use all that space. Varchar and nvarchar are Variable-length ...