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 |
How can we delete Duplicate row in table?
Explain what are commit and rollback in sql?
What is difference between views and tables?
How do I shrink an ldf file?
What the different components of Replication and what is their use?
can you any body tell me suppose database is suspect mode. how can take to normal?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is the difference between login and a user?
13 Answers CTS, TCS,
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
How to define and use table alias names in ms sql server?
What is a non-clustered index?
How sql server executes a statement with nested subqueries?
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)