{"id":61,"date":"2012-12-20T13:02:21","date_gmt":"2012-12-20T16:02:21","guid":{"rendered":"https:\/\/maurobernal.com.ar\/blog\/?p=61"},"modified":"2013-11-21T12:01:32","modified_gmt":"2013-11-21T15:01:32","slug":"usando-mysql-varbinary-con-linq-to-entities","status":"publish","type":"post","link":"https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/","title":{"rendered":"Usando MYSQL varbinary con Linq to Entities"},"content":{"rendered":"

Continuando mi proyecto de realizar un integrador de una base MYSQL<\/strong> con una base MSSQL<\/strong>, me encontr\u00e9 un nuevo problema con los campos VARBINARY<\/strong>.
\n<\/span><\/p>\n

B\u00e1sicamente en ellos guardada textos planos, pero al ser VARBINARY<\/strong>, LINQ to ENTITIES<\/strong> los trataba como ARRAYS<\/strong> (binarios). Para convertir los valores use la siguiente funci\u00f3n:
\n<\/span><\/p>\n

system.text.Encoding.ASCII.GetString(tabla.campo).
\n<\/strong><\/span><\/p>\n

\n\u00a0<\/p>\n

Los tipos <\/span>BINARY<\/strong><\/span> y <\/span>VARBINARY<\/strong><\/span> son similares a <\/span>CHAR<\/strong><\/span> y <\/span>VARCHAR<\/strong><\/span>, excepto que contienen cadenas de caracteres binarias en lugar de cadenas de caracteres no binarias. Esto es, contienen cadenas de bytes en lugar de cadenas de caracteres. Esto significa que no tienen conjunto de caracteres asignado, y la comparaci\u00f3n y ordenaci\u00f3n se basa en los valores num\u00e9ricos de los valores de los bytes<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Continuando mi proyecto de realizar un integrador de una base MYSQL con una base MSSQL, me encontr\u00e9 un nuevo problema con los campos VARBINARY. B\u00e1sicamente en ellos guardada textos planos,…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4,5,3],"tags":[38,39,8,7,42,41,40],"class_list":["post-61","post","type-post","status-publish","format-standard","hentry","category-mssql","category-mysql","category-t-sql","tag-net","tag-c","tag-mssql-2","tag-mysql-2","tag-sql2005","tag-sql2008","tag-vs2010"],"yoast_head":"\nUsando MYSQL varbinary con Linq to Entities · devops Mauro Bernal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Usando MYSQL varbinary con Linq to Entities · devops Mauro Bernal\" \/>\n<meta property=\"og:description\" content=\"Continuando mi proyecto de realizar un integrador de una base MYSQL con una base MSSQL, me encontr\u00e9 un nuevo problema con los campos VARBINARY. B\u00e1sicamente en ellos guardada textos planos,...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/\" \/>\n<meta property=\"og:site_name\" content=\"devops Mauro Bernal\" \/>\n<meta property=\"article:published_time\" content=\"2012-12-20T16:02:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-11-21T15:01:32+00:00\" \/>\n<meta name=\"author\" content=\"Mauro Bernal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@_maurobernal\" \/>\n<meta name=\"twitter:site\" content=\"@_maurobernal\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mauro Bernal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/usando-mysql-varbinary-con-linq-to-entities\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/usando-mysql-varbinary-con-linq-to-entities\\\/\"},\"author\":{\"name\":\"Mauro Bernal\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"headline\":\"Usando MYSQL varbinary con Linq to Entities\",\"datePublished\":\"2012-12-20T16:02:21+00:00\",\"dateModified\":\"2013-11-21T15:01:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/usando-mysql-varbinary-con-linq-to-entities\\\/\"},\"wordCount\":133,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"keywords\":[\".NET\",\"c#\",\"mssql\",\"mysql\",\"sql2005\",\"sql2008\",\"vs2010\"],\"articleSection\":[\"MSSQL\",\"MYSQL\",\"T-SQL\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/usando-mysql-varbinary-con-linq-to-entities\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/usando-mysql-varbinary-con-linq-to-entities\\\/\",\"url\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/usando-mysql-varbinary-con-linq-to-entities\\\/\",\"name\":\"Usando MYSQL varbinary con Linq to Entities · devops Mauro Bernal\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#website\"},\"datePublished\":\"2012-12-20T16:02:21+00:00\",\"dateModified\":\"2013-11-21T15:01:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/usando-mysql-varbinary-con-linq-to-entities\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/usando-mysql-varbinary-con-linq-to-entities\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/usando-mysql-varbinary-con-linq-to-entities\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Usando MYSQL varbinary con Linq to Entities\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/\",\"name\":\"devops Mauro Bernal\",\"description\":\"Cuando tu trabajo es hacer que las cosas funcionen bien...\",\"publisher\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\",\"name\":\"Mauro Bernal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\",\"width\":1740,\"height\":1740,\"caption\":\"Mauro Bernal\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\"},\"description\":\"Desarrollo de Sistemas en .Net, IT Callcenters, DBA de SQL Server, Mikrotik, Pentest y T\u00e9cnico consultor de Sistemas Bejerman\",\"sameAs\":[\"https:\\\/\\\/maurobernal.com.ar\",\"https:\\\/\\\/x.com\\\/_maurobernal\",\"https:\\\/\\\/youtube.com\\\/maurobernal\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Usando MYSQL varbinary con Linq to Entities · devops Mauro Bernal","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:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/","og_locale":"es_ES","og_type":"article","og_title":"Usando MYSQL varbinary con Linq to Entities · devops Mauro Bernal","og_description":"Continuando mi proyecto de realizar un integrador de una base MYSQL con una base MSSQL, me encontr\u00e9 un nuevo problema con los campos VARBINARY. B\u00e1sicamente en ellos guardada textos planos,...","og_url":"https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/","og_site_name":"devops Mauro Bernal","article_published_time":"2012-12-20T16:02:21+00:00","article_modified_time":"2013-11-21T15:01:32+00:00","author":"Mauro Bernal","twitter_card":"summary_large_image","twitter_creator":"@_maurobernal","twitter_site":"@_maurobernal","twitter_misc":{"Escrito por":"Mauro Bernal","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/#article","isPartOf":{"@id":"https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/"},"author":{"name":"Mauro Bernal","@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"headline":"Usando MYSQL varbinary con Linq to Entities","datePublished":"2012-12-20T16:02:21+00:00","dateModified":"2013-11-21T15:01:32+00:00","mainEntityOfPage":{"@id":"https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/"},"wordCount":133,"commentCount":0,"publisher":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"keywords":[".NET","c#","mssql","mysql","sql2005","sql2008","vs2010"],"articleSection":["MSSQL","MYSQL","T-SQL"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/","url":"https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/","name":"Usando MYSQL varbinary con Linq to Entities · devops Mauro Bernal","isPartOf":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#website"},"datePublished":"2012-12-20T16:02:21+00:00","dateModified":"2013-11-21T15:01:32+00:00","breadcrumb":{"@id":"https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/maurobernal.com.ar\/blog\/usando-mysql-varbinary-con-linq-to-entities\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/maurobernal.com.ar\/blog\/"},{"@type":"ListItem","position":2,"name":"Usando MYSQL varbinary con Linq to Entities"}]},{"@type":"WebSite","@id":"https:\/\/maurobernal.com.ar\/blog\/#website","url":"https:\/\/maurobernal.com.ar\/blog\/","name":"devops Mauro Bernal","description":"Cuando tu trabajo es hacer que las cosas funcionen bien...","publisher":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/maurobernal.com.ar\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283","name":"Mauro Bernal","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1","url":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1","contentUrl":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1","width":1740,"height":1740,"caption":"Mauro Bernal"},"logo":{"@id":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1"},"description":"Desarrollo de Sistemas en .Net, IT Callcenters, DBA de SQL Server, Mikrotik, Pentest y T\u00e9cnico consultor de Sistemas Bejerman","sameAs":["https:\/\/maurobernal.com.ar","https:\/\/x.com\/_maurobernal","https:\/\/youtube.com\/maurobernal"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/61","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/comments?post=61"}],"version-history":[{"count":2,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/61\/revisions"}],"predecessor-version":[{"id":87,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/61\/revisions\/87"}],"wp:attachment":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/media?parent=61"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/categories?post=61"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/tags?post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}