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 do we have to check in database testing?
Explain what role entity and relationship play in an ER diagram.
What stored by the tempdb ? : sql server database administration
internal language used in sql server 2000?
How cand Optimize SQL Server Stored Procedures
What are the properties of sub-query?
Difference between DELETE and TRUNCATE?
What is the server name in sql server?
What types of integrity are enforced by a foreign-key constraint
What is a primary index?
Explain insert into select statement?
How do I create an extended event in sql server?
Oracle (3253)
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)