1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what is difference between nchar and char in Sql server ?

Question Posted / arijit bhawal

Answers were Sorted based on User's Feedback



what is difference between nchar and char in Sql server ? ..

Answer / dinesh

nChar Support Unicode Character but char Does Not
Support

Is This Answer Correct ?    23 Yes 0 No

what is difference between nchar and char in Sql server ? ..

Answer / 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

what is difference between nchar and char in Sql server ? ..

Answer / parantap

char support ANSI code character but nchar support unicode character.
:-char reserve 1 byte memory space but nchar reserve 2byte memory space.

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Why Do you want to work in this company?

4 Answers   HCL,

How you can move data or databases between servers and databases in sql server?

0 Answers  

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

Do you know the isolation level that sql server support?

0 Answers  

what is normalization? what is denormalization?

9 Answers   Satyam,




Explain what is “asynchronous” communication in sql server service broker?

0 Answers  

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

Why olap is used?

0 Answers  

Explain what is scheduled job and how to create it?

0 Answers  

What is difference between index and primary key?

0 Answers  

Explain what is row_number function?

0 Answers  

What is filter index?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories