HomePage
Jobs
WalkIn
Articles
Group Chat
Contact Us
Feedback
Sitemap
To improves our performance please Like Share Subscribe(Will boost us)
Follow
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.
But both different data types one have nchar(3) and another have char(3). Below is the difference
0
0
Base Of Difference
nchar(3)
char(3)
Size
It will take 6 bytes 2 bytes for every charcter
It will take 3 bytes 1 bytes for each charcter
Character Type
It 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.
.
Most Visited Questions:-
Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a
More...
Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra
More...
Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres
More...
What is Gulpjs and some multiple choice questions on Gulp
Gulpjs is an open source whihc helps in building Javascript
More...
Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec
More...
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
@2014-2022 Crackyourinterview (All rights reserved)
Privacy Policy - Disclaimer - Sitemap