what is difference between nchar and char in Sql server ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what are triggers? : Sql server database administration

661


A trigger can reference objects outside the current database? State true or false.

745


Your table has a large character field there are queries that use this field in their search clause what should you do?

694


List some case manipulation functions in sql?

775


You are doing log shipping due to some reasons it is failing. How you will proceed from there

1753






What are sp_configure commands and set commands?

721


How many types of objects are there?

685


Explain what is meant by replication of database?

720


what is denormalization? : Sql server database administration

654


How to get the number of affected rows?

736


Describe in brief authentication modes in sql server.

733


What is data compression? : sql server database administration

704


Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

745


Do comments need to go in a special place in sql server 2005?

650


what is normalization? : Sql server database administration

741