tag:blogger.com,1999:blog-7805972021499203804.post9211997274424243150..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: Difference between char varchar and nvarchar in sql serverSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger32125tag:blogger.com,1999:blog-7805972021499203804.post-34365603439458092342018-08-06T05:07:05.307-07:002018-08-06T05:07:05.307-07:00Good jobGood jobAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-24615009604667990402016-06-07T03:27:37.986-07:002016-06-07T03:27:37.986-07:00I think varchar is enough...why these two more cha...I think varchar is enough...why these two more char,nvarchar,,pls explainHiihttps://www.blogger.com/profile/08722068091083683109noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-78075291069003816672016-01-04T02:45:03.373-08:002016-01-04T02:45:03.373-08:00Actually Varchar is used to store non-unicode char...Actually Varchar is used to store non-unicode characters.and nvarchar store unicode characters, Non-unicode takes 1 byte storage and unicode takes 2 byte storage.<br />I hope it would help to understand above concept what suresh sir tried to explain. :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-30200185735143230912015-07-06T04:42:18.307-07:002015-07-06T04:42:18.307-07:00A very nice and detailed explanation , and easily ...A very nice and detailed explanation , and easily understandable.Paul Leubenhttps://www.calipus.innoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-24228769994484089272015-03-23T10:21:03.052-07:002015-03-23T10:21:03.052-07:00You can insert any language like Hindi, Urdu or Ch...You can insert any language like Hindi, Urdu or Chinese. But varchar doesn't allow to store those characters Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-24066880839034138522014-08-29T06:03:43.154-07:002014-08-29T06:03:43.154-07:00simply defined and easily understandable nice........simply defined and easily understandable nice.......Anonymoushttps://www.blogger.com/profile/15856593396563861263noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-52260863301420967292014-06-30T21:09:34.794-07:002014-06-30T21:09:34.794-07:00gud one.. everything clearly describedgud one.. everything clearly describedAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-71089119772086484462014-04-07T22:23:24.214-07:002014-04-07T22:23:24.214-07:00Great explanation sir....Thanks specially for depi...Great explanation sir....Thanks specially for depicting the clear picture between varchar & nvarchar . Anonymoushttps://www.blogger.com/profile/06095271717147849479noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-90641038980684466172014-03-12T22:25:51.119-07:002014-03-12T22:25:51.119-07:00very good explanation...........very good explanation...........Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-43470180830210342922013-12-15T21:37:07.441-08:002013-12-15T21:37:07.441-08:00enough to move forwardenough to move forwardAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-27924568461472287272013-08-15T02:58:18.090-07:002013-08-15T02:58:18.090-07:00Nice but not clear nvarchar....... Nice but not clear nvarchar....... Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-79122459459898604592013-08-07T00:40:36.683-07:002013-08-07T00:40:36.683-07:00wat is unicode???wat is unicode???Anonymoushttps://www.blogger.com/profile/15033508149069868572noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-25634079594295716312013-08-06T22:56:27.967-07:002013-08-06T22:56:27.967-07:00Good Article.....Good Article.....Veersh Dachepallyhttps://www.blogger.com/profile/15162092352823417102noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-47783053084290778642013-07-13T00:45:42.803-07:002013-07-13T00:45:42.803-07:00Nice OneNice OneAnonymoushttps://www.blogger.com/profile/17986137889626558316noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-90309671151587672562013-06-27T04:50:11.797-07:002013-06-27T04:50:11.797-07:00best explanation...best explanation...imrannoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-40351246968707791512013-06-25T23:41:21.257-07:002013-06-25T23:41:21.257-07:00nice article
nice article<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-63060704544712553622013-06-18T23:10:50.501-07:002013-06-18T23:10:50.501-07:00As you described difference between char varchar a...As you described difference between char varchar and nvarchar in sql server is really appreciate because this helps to those who are in fresher level.Eone Jameshttp://www.elantechnologies.com/services/web-apps/asp-net-ms-sql-development/noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-55580821668448411552013-06-12T01:32:37.776-07:002013-06-12T01:32:37.776-07:00yup seriously..
what do u mean by multiple languag...yup seriously..<br />what do u mean by multiple languages in db.. is this for english , gujarati and all that type of thing?Anonymoushttps://www.blogger.com/profile/08973537592232196098noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-19579914345719873552013-06-07T23:37:18.263-07:002013-06-07T23:37:18.263-07:00keep it up brother....really very very simple expl...keep it up brother....really very very simple explanation...tkcrAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-3324854881645030102013-05-03T23:47:31.472-07:002013-05-03T23:47:31.472-07:00Really awesome explanation regarding SQL server. W...Really awesome explanation regarding SQL server. Would you please do this for MySQL as well?Software Development Company Indiahttp://www.calipus.com/noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-14527165026026803472013-04-15T01:59:42.156-07:002013-04-15T01:59:42.156-07:00I have read about difference between char varchar ...I have read about difference between char varchar and nvarchar in sql server in this article. I think you have well tried to explain through this post. Well Done.William Moorehttp://www.calipus.comnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-87258616895932369152013-03-29T05:46:53.133-07:002013-03-29T05:46:53.133-07:00This website useful for who learn sql r .net.Thanx...This website useful for who learn sql r .net.Thanx<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-54575270670916591812013-03-09T23:04:35.042-08:002013-03-09T23:04:35.042-08:00Say if ur migrating ur application to multilingual...Say if ur migrating ur application to multilingual application in that scenario ur application should support all languages like chines, japnese ...hence in db side u need to chane the table structure in such a way to insert even there lanuage characters too ( as they occupy more space).hence we go for nvarchar datatype for string operations..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-4668924314856788892013-03-05T22:48:30.854-08:002013-03-05T22:48:30.854-08:00very very clear explainationvery very clear explainationAnonymoushttps://www.blogger.com/profile/13969976130419955858noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-29208250111198320992012-11-04T21:36:38.922-08:002012-11-04T21:36:38.922-08:00varchar allocates memory dynamically?
in Oracle we...varchar allocates memory dynamically?<br />in Oracle we Can use Varchar2<br />Anonymousnoreply@blogger.com