{"id":4813,"date":"2021-12-03T21:36:20","date_gmt":"2021-12-03T21:36:20","guid":{"rendered":"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/"},"modified":"2021-12-03T21:36:20","modified_gmt":"2021-12-03T21:36:20","slug":"varchar-e-nvarchar","status":"publish","type":"post","link":"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/","title":{"rendered":"Diferen\u00e7a entre Varchar e Nvarchar"},"content":{"rendered":"

\"Diferen\u00e7a<\/p>\n

\n

Principal diferen\u00e7a<\/h2>\n

Varchar e nvarchar s\u00e3o variedades de dados no SQL Server. O predominante entre varchar e narchar \u00e9 que narchar \u00e9 usado para armazenar caracteres Unicode, enquanto varchar \u00e9 usado para armazenar caracteres n\u00e3o Unicode. O armazenamento de dados \u00e9 de 1 byte por caractere em varchar, enquanto o armazenamento de informa\u00e7\u00f5es em nvarchar \u00e9 de 2 bytes por caractere. Na defini\u00e7\u00e3o do tema, varchar suporta at\u00e9 8.000 caracteres, enquanto nvarchar suporta at\u00e9 4.000 caracteres.<\/p>\n

O que \u00e9 Varchar?<\/h2>\n

Varchar \u00e9 um tipo de dados AQL Server que pertence a caracteres vari\u00e1veis. Caracteres n\u00e3o Unicode s\u00e3o salvos usando varchar. A aloca\u00e7\u00e3o de mem\u00f3ria em varchar \u00e9 de acordo com os caracteres inseridos. Na defini\u00e7\u00e3o do tema, varchar ajuda at\u00e9 8000 caracteres.<\/p>\n

O que \u00e9 Nvarchar?<\/h2>\n

Nvarchar \u00e9 um tipo de dados do SQL Server que pertence a vari\u00e1veis \u200b\u200bde caracteres. Caracteres Unicode s\u00e3o salvos usando nvarchar. \u00c9 prov\u00e1vel que v\u00e1rios idiomas sejam salvos na base de informa\u00e7\u00f5es. Se outros idiomas forem usados, o nvarchar ocupar\u00e1 o dobro do espa\u00e7o para armazenar um conjunto estendido de caracteres. Na defini\u00e7\u00e3o arquivada, nvarchar ajuda at\u00e9 4000 caracteres.<\/p>\n

Principais diferen\u00e7as<\/h2>\n
    \n
  1. Narchar \u00e9 usado para armazenar caracteres Unicode, enquanto varchar n\u00e3o armazena caracteres Unicode.<\/li>\n
  2. Varchar \u00e9 usado para armazenar caracteres n\u00e3o Unicode, enquanto nvarchar n\u00e3o armazena caracteres n\u00e3o Unicode.<\/li>\n
  3. Armazenamento de dados 1 byte por caractere em varchar enquanto em narchar o armazenamento de informa\u00e7\u00f5es n\u00e3o \u00e9 simplesmente 1 byte por caractere.<\/li>\n
  4. O armazenamento de dados em nvarchar \u00e9 de 2 bytes por caractere, enquanto o armazenamento de informa\u00e7\u00f5es de varchar simplesmente n\u00e3o \u00e9 de 2 bytes por caractere.<\/li>\n
  5. Na defini\u00e7\u00e3o do tema, varchar suporta at\u00e9 8.000 caracteres, enquanto nvarchar suporta at\u00e9 4.000 caracteres.<\/li>\n
  6. A aloca\u00e7\u00e3o de mem\u00f3ria em varchar \u00e9 semelhante ao n\u00famero de caracteres inseridos mais dois bytes extras para deslocamento, enquanto em nvarchar a aloca\u00e7\u00e3o de mem\u00f3ria \u00e9 semelhante a duas vezes o n\u00famero de caracteres inseridos mais dois bytes extras para deslocamento.<\/li>\n
  7. Se tamb\u00e9m pode haver caracteres Unicode para salvar em uma coluna ou vari\u00e1vel, usamos varchar enquanto no outro aspecto, se houver caracteres n\u00e3o Unicode para salvar em uma coluna ou vari\u00e1vel, usamos nvarchar.<\/li>\n
  8. Na declara\u00e7\u00e3o da vari\u00e1vel ou na defini\u00e7\u00e3o da coluna, se o par\u00e2metro n\u00e3o obrigat\u00f3rio valve n simplesmente n\u00e3o for especificado, sup\u00f5e-se que seja 1 para varchar e 2 para nvarchar.<\/li>\n<\/ol>\n

    V\u00eddeo Comparativo<\/h2>\n

    Error 403 The request cannot be completed because you have exceeded your quota<\/a>. : quotaExceeded<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Principal diferen\u00e7a Varchar e nvarchar s\u00e3o variedades de dados no SQL Server. O predominante entre varchar e narchar \u00e9 que narchar \u00e9 usado para armazenar caracteres Unicode, enquanto varchar \u00e9 usado para armazenar caracteres n\u00e3o Unicode. O armazenamento de dados \u00e9 de 1 byte por caractere em varchar, enquanto o armazenamento de informa\u00e7\u00f5es em nvarchar … Leia mais<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4161],"tags":[4030,4029],"class_list":["post-4813","post","type-post","status-publish","format-standard","hentry","category-rede","tag-nvarchar","tag-varchar","no-featured-image-padding"],"yoast_head":"\nDiferen\u00e7a entre Varchar e Nvarchar<\/title>\n<meta name=\"description\" content=\"lll\u27a4 Principal diferen\u00e7a Varchar e nvarchar s\u00e3o variedades de dados no SQL Server. O predominante entre varchar e narchar \u00e9 que narchar \u00e9 usado para armazenar\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Diferen\u00e7a entre Varchar e Nvarchar\" \/>\n<meta property=\"og:description\" content=\"lll\u27a4 Principal diferen\u00e7a Varchar e nvarchar s\u00e3o variedades de dados no SQL Server. O predominante entre varchar e narchar \u00e9 que narchar \u00e9 usado para armazenar\" \/>\n<meta property=\"og:url\" content=\"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/\" \/>\n<meta property=\"og:site_name\" content=\"Diferenciario br\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-03T21:36:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/diferenciario.com\/br\/wp-content\/uploads\/varchar-e-nvarchar.webp\" \/>\n<meta name=\"author\" content=\"javiervazquez_5mia2u1h\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/\"},\"author\":{\"name\":\"javiervazquez_5mia2u1h\",\"@id\":\"https:\/\/diferenciario.com\/br\/#\/schema\/person\/56d044ad3bc3481dd45252b40b46ac75\"},\"headline\":\"Diferen\u00e7a entre Varchar e Nvarchar\",\"datePublished\":\"2021-12-03T21:36:20+00:00\",\"dateModified\":\"2021-12-03T21:36:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/\"},\"wordCount\":429,\"publisher\":{\"@id\":\"https:\/\/diferenciario.com\/br\/#organization\"},\"keywords\":[\"Nvarchar\",\"Varchar\"],\"articleSection\":[\"Rede\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/\",\"url\":\"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/\",\"name\":\"Diferen\u00e7a entre Varchar e Nvarchar\",\"isPartOf\":{\"@id\":\"https:\/\/diferenciario.com\/br\/#website\"},\"datePublished\":\"2021-12-03T21:36:20+00:00\",\"dateModified\":\"2021-12-03T21:36:20+00:00\",\"description\":\"lll\u27a4 Principal diferen\u00e7a Varchar e nvarchar s\u00e3o variedades de dados no SQL Server. O predominante entre varchar e narchar \u00e9 que narchar \u00e9 usado para armazenar\",\"breadcrumb\":{\"@id\":\"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/diferenciario.com\/br\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Diferen\u00e7a entre Varchar e Nvarchar\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/diferenciario.com\/br\/#website\",\"url\":\"https:\/\/diferenciario.com\/br\/\",\"name\":\"Diferenciario br\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/diferenciario.com\/br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/diferenciario.com\/br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/diferenciario.com\/br\/#organization\",\"name\":\"Diferenciario br\",\"url\":\"https:\/\/diferenciario.com\/br\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/diferenciario.com\/br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/diferenciario.com\/br\/wp-content\/uploads\/logo-diferenciario-brazil.webp\",\"contentUrl\":\"https:\/\/diferenciario.com\/br\/wp-content\/uploads\/logo-diferenciario-brazil.webp\",\"width\":225,\"height\":33,\"caption\":\"Diferenciario br\"},\"image\":{\"@id\":\"https:\/\/diferenciario.com\/br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/diferenciario.com\/br\/#\/schema\/person\/56d044ad3bc3481dd45252b40b46ac75\",\"name\":\"javiervazquez_5mia2u1h\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/diferenciario.com\/br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8826c6e0d313911ff94b887c5c66bafcf74cfe0a1f0c1fcd76cc1a5400186f2e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8826c6e0d313911ff94b887c5c66bafcf74cfe0a1f0c1fcd76cc1a5400186f2e?s=96&d=mm&r=g\",\"caption\":\"javiervazquez_5mia2u1h\"},\"sameAs\":[\"https:\/\/diferenciario.com\/br\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Diferen\u00e7a entre Varchar e Nvarchar","description":"lll\u27a4 Principal diferen\u00e7a Varchar e nvarchar s\u00e3o variedades de dados no SQL Server. O predominante entre varchar e narchar \u00e9 que narchar \u00e9 usado para armazenar","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/","og_locale":"es_ES","og_type":"article","og_title":"Diferen\u00e7a entre Varchar e Nvarchar","og_description":"lll\u27a4 Principal diferen\u00e7a Varchar e nvarchar s\u00e3o variedades de dados no SQL Server. O predominante entre varchar e narchar \u00e9 que narchar \u00e9 usado para armazenar","og_url":"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/","og_site_name":"Diferenciario br","article_published_time":"2021-12-03T21:36:20+00:00","og_image":[{"url":"https:\/\/diferenciario.com\/br\/wp-content\/uploads\/varchar-e-nvarchar.webp"}],"author":"javiervazquez_5mia2u1h","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/#article","isPartOf":{"@id":"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/"},"author":{"name":"javiervazquez_5mia2u1h","@id":"https:\/\/diferenciario.com\/br\/#\/schema\/person\/56d044ad3bc3481dd45252b40b46ac75"},"headline":"Diferen\u00e7a entre Varchar e Nvarchar","datePublished":"2021-12-03T21:36:20+00:00","dateModified":"2021-12-03T21:36:20+00:00","mainEntityOfPage":{"@id":"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/"},"wordCount":429,"publisher":{"@id":"https:\/\/diferenciario.com\/br\/#organization"},"keywords":["Nvarchar","Varchar"],"articleSection":["Rede"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/","url":"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/","name":"Diferen\u00e7a entre Varchar e Nvarchar","isPartOf":{"@id":"https:\/\/diferenciario.com\/br\/#website"},"datePublished":"2021-12-03T21:36:20+00:00","dateModified":"2021-12-03T21:36:20+00:00","description":"lll\u27a4 Principal diferen\u00e7a Varchar e nvarchar s\u00e3o variedades de dados no SQL Server. O predominante entre varchar e narchar \u00e9 que narchar \u00e9 usado para armazenar","breadcrumb":{"@id":"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/diferenciario.com\/br\/varchar-e-nvarchar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/diferenciario.com\/br\/"},{"@type":"ListItem","position":2,"name":"Diferen\u00e7a entre Varchar e Nvarchar"}]},{"@type":"WebSite","@id":"https:\/\/diferenciario.com\/br\/#website","url":"https:\/\/diferenciario.com\/br\/","name":"Diferenciario br","description":"","publisher":{"@id":"https:\/\/diferenciario.com\/br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/diferenciario.com\/br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/diferenciario.com\/br\/#organization","name":"Diferenciario br","url":"https:\/\/diferenciario.com\/br\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/diferenciario.com\/br\/#\/schema\/logo\/image\/","url":"https:\/\/diferenciario.com\/br\/wp-content\/uploads\/logo-diferenciario-brazil.webp","contentUrl":"https:\/\/diferenciario.com\/br\/wp-content\/uploads\/logo-diferenciario-brazil.webp","width":225,"height":33,"caption":"Diferenciario br"},"image":{"@id":"https:\/\/diferenciario.com\/br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/diferenciario.com\/br\/#\/schema\/person\/56d044ad3bc3481dd45252b40b46ac75","name":"javiervazquez_5mia2u1h","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/diferenciario.com\/br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8826c6e0d313911ff94b887c5c66bafcf74cfe0a1f0c1fcd76cc1a5400186f2e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8826c6e0d313911ff94b887c5c66bafcf74cfe0a1f0c1fcd76cc1a5400186f2e?s=96&d=mm&r=g","caption":"javiervazquez_5mia2u1h"},"sameAs":["https:\/\/diferenciario.com\/br"]}]}},"_links":{"self":[{"href":"https:\/\/diferenciario.com\/br\/wp-json\/wp\/v2\/posts\/4813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/diferenciario.com\/br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/diferenciario.com\/br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/diferenciario.com\/br\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/diferenciario.com\/br\/wp-json\/wp\/v2\/comments?post=4813"}],"version-history":[{"count":0,"href":"https:\/\/diferenciario.com\/br\/wp-json\/wp\/v2\/posts\/4813\/revisions"}],"wp:attachment":[{"href":"https:\/\/diferenciario.com\/br\/wp-json\/wp\/v2\/media?parent=4813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/diferenciario.com\/br\/wp-json\/wp\/v2\/categories?post=4813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/diferenciario.com\/br\/wp-json\/wp\/v2\/tags?post=4813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}