{"id":247,"date":"2015-01-19T09:20:00","date_gmt":"2015-01-19T09:20:00","guid":{"rendered":"https:\/\/blogfvinhas.wordpress.com\/?p=247"},"modified":"2015-01-19T09:20:00","modified_gmt":"2015-01-19T09:20:00","slug":"erro-sql-online-string-or-binary-data-would-be-truncated-the-statement-has-been-terminated","status":"publish","type":"post","link":"https:\/\/blog.fvinhas.com\/index.php\/2015\/01\/19\/erro-sql-online-string-or-binary-data-would-be-truncated-the-statement-has-been-terminated\/","title":{"rendered":"Erro SQL online \u2013 String or binary data would be truncated. The statement has been terminated."},"content":{"rendered":"\n<p>Para quem est\u00e1 a desenvolver uma pequena aplica\u00e7\u00e3o web, ao carregar dados para uma base de dados online por vezes aparecem erros com os quais n\u00e3o nos identificamos, ou n\u00e3o conseguimos descobrir os diversos motivos.<\/p>\n\n\n\n<p>O erro identificado na imagem abaixo deve-se essencialmente ao fato de num dos campos ou em v\u00e1rios existir um n\u00famero superior de caracteres que na base de dados n\u00e3o possui.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"267\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-77.png?w=640\" alt=\"\" class=\"wp-image-248\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-77.png 640w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-77-300x125.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>Para resolver este problema podem:<\/p>\n\n\n\n<p>&#8211; Aumentar o n\u00famero de caracteres do campo pretendido (no design da Base de Dados)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"359\" height=\"207\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-78.png?w=359\" alt=\"\" class=\"wp-image-249\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-78.png 359w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-78-300x173.png 300w\" sizes=\"auto, (max-width: 359px) 100vw, 359px\" \/><\/figure>\n\n\n\n<p>&#8211; Limitar o n\u00famero de caracteres na altura da introdu\u00e7\u00e3o, sendo que o erro j\u00e1 n\u00e3o aparece. (nas propriedades da caixa de texto, exemplo em Visual Studio)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"220\" height=\"325\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-79.png?w=220\" alt=\"\" class=\"wp-image-250\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-79.png 220w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-79-203x300.png 203w\" sizes=\"auto, (max-width: 220px) 100vw, 220px\" \/><\/figure>\n\n\n\n<p>Espero ter ajudado.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Para quem est\u00e1 a desenvolver uma pequena aplica\u00e7\u00e3o web, ao carregar dados para uma base de dados online por vezes aparecem erros com os quais n\u00e3o nos identificamos, ou n\u00e3o conseguimos descobrir os diversos motivos. O erro identificado na imagem abaixo deve-se essencialmente ao fato de num dos campos ou em v\u00e1rios existir um n\u00famero &#8230; <a title=\"Erro SQL online \u2013 String or binary data would be truncated. The statement has been terminated.\" class=\"read-more\" href=\"https:\/\/blog.fvinhas.com\/index.php\/2015\/01\/19\/erro-sql-online-string-or-binary-data-would-be-truncated-the-statement-has-been-terminated\/\" aria-label=\"Read more about Erro SQL online \u2013 String or binary data would be truncated. The statement has been terminated.\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[70],"class_list":["post-247","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-programing-sql"],"_links":{"self":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts\/247","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/comments?post=247"}],"version-history":[{"count":0,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts\/247\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/media?parent=247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/categories?post=247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/tags?post=247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}