char support ANSI code character but nchar support unicode character. :-ch

what is difference between nchar and char in Sql server ?

Question Posted / parantap

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

Please Help Members By Posting Answers For Below Questions

What is exporting and importing utility?

1015

What is the difference between value type and reference type?

867

How to override dml statements with triggers?

1069

Mention the command used to rename the database.

945

Which sql server table is used to hold the stored procedure scripts?

1024

What is normalization process?

1105

What are SSL and TSL protocols?

931

What is repeatable read?

933

How does normalization work?

864

What is raid, and how it can influence database performance?

1005

What is co-related sub query?

973

Does transparent data encryption provide encryption when transmitting data across the network?

980

How to move database physical files in ms sql server?

955

What is schemabinding a view?

858

What is molap and its advantage? : sql server analysis services, ssas

928