what is difference between nchar and char in Sql server ?
Answers were Sorted based on User's Feedback
Answer / dinesh
nChar Support Unicode Character but char Does Not
Support
| Is This Answer Correct ? | 23 Yes | 0 No |
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 |
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 |
What are the types of stored procedures in an sql server?
What is WITH CHECK OPTION
3 Answers Karur Vysya Bank KVB,
How to create a testing table with test data in ms sql server?
What are the types of indexing?
What is a unique index?
what is Constraint? How many types of constraints in SQL ?
38 Answers HCL, IBM, NIIT, Wipro,
What will be the maximum number of indexes per table?
How do you identify a foreign key?
A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?
How can sql injection be stopped? : sql server security
is there more the two primary key in a single table?
26 Answers Eforce, Systematix,
What type of locking occurs during the snapshot generation? : sql server replication
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)