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 is the new security features added in sql server 2014? : sql server security
How you provide security to cube? : sql server analysis services, ssas
In the primary key have a multiple field or not?
What is multi-statement table-value user-defined function?
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?
Why are views required in the sql server or in any other database?
What is the purpose of update statistics and scope_identity() function?
How to find related tables in sql server?
Why do we partition data?
Explain insert into select statement?
How to Install SQL SERVER 2005 remotely?
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)