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 to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
How to execute stored procedure in select statement sql server?
What is a synonym for manipulation?
What is the sql case statement used for?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
How do I find the sql server instance name?
Write a SQL command to insert and update only a particular field?
What is the default isolation level of the sql server database?
how to determine the service pack currently installed on sql server? : Sql server database administration
What do you mean by SQL injection attack?
How to filter out duplications in the returning rows in ms sql server?
What is the use of CASCADE CONSTRAINTS?
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)