Hi Guest

MobileUser

1 HomePage 1 Jobs 1 WalkIn 1Articles  

Cat Exam

 :) Latest Topic
AJAX
VB.NET
SQL Query
UDDI
CLASS
JavaScript Questions
SharePoint Interview
SilverLight
WCF
general knowledge
 ASP.NET
 :) Hot Jobs
 
 :) Latest Articles


  

 


We have define nchar(3) and char(3) what is difference?
Question Posted on 11 Sep 2021

Home >> DataBase >> SQL Query >> We have define nchar(3) and char(3) what is difference?




We have define nchar(3) and char(3) what is difference?
We have created a Table and define two column CountryName and CountryName1 in it.

nvarchar in sql
But both different data types one have nchar(3) and another have char(3). Below is the difference
0
0

Base Of Differencenchar(3)char(3)
SizeIt will take 6 bytes 2 bytes for every charcterIt will take 3 bytes 1 bytes for each charcter
Character TypeIt will store unicode character as well like chinese , some curreny types and some other unicode values other then english and number system.This will only takes numeric and aplhanumeric charcters like a-z,A-Z and 0-9.


 
 Input Your Comments Or suggestions(If Any)
 Name
 Email(optional)
 Comments


Other Important Questions
How to get the table count in last used query from cache by sending tablename?
Write a SQL query to print 1 to 100 in sql server?
Sql Interview Latest Query questions asked on 30 dec 2020
nth highest number from table
some good sql query






 
Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |