what is difference between nchar and char in Sql server ?

Answer Posted / ruchika mathur

N stands for national character and it is meant for Unicode
data.Using Unicode data types,a column can store the data
defined by Unicode standard. that's why nchar supports
Unicode character whereas char does not.

Is This Answer Correct ?    15 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you know if the row fetched from cursor is still valid in underlying table?

760


What are the differences between stored procedure and view in sql server?

838


Why do we need normalization?

663


What is 2nf normalization form?

776


You want to implement the one-to-many relationship while designing tables. How would you do it?

709






How to read data in a table with "select" statements?

735


How to create new tables with "create table" statements in ms sql server?

759


What function does a database engine serve in the sql server?

762


What are the restrictions that views have to follow? : SQL Server Architecture

745


Is it possible to update the views? If yes, how, if not, why?

707


Explain the working of sql privileges?

800


What is instead of trigger sql server?

673


What are the types of joins in sql?

776


Explain the difference between function and stored procedure?

681


How to test odbc dsn connection settings?

706