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

How to find the source of a table in sql server?

0 Answers  

List some case manipulation functions in sql?

0 Answers  

What is the full meaning of dml?

0 Answers  

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

Explain about temporary stored procedure?

0 Answers  




What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

0 Answers  

What can be used instead of trigger?

0 Answers   ADITI,

What are relationships and mention different types of relationships in the dbms

0 Answers  

Can you please differentiate between a primary key and a unique key?

0 Answers  

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

How to set database to be single_user in ms sql server?

0 Answers  

What is blocking?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories