{"id":394,"date":"2017-07-06T16:15:50","date_gmt":"2017-07-06T16:15:50","guid":{"rendered":"https:\/\/blogs.ua.es\/jpm33\/?p=394"},"modified":"2017-07-06T16:15:50","modified_gmt":"2017-07-06T16:15:50","slug":"obtener-contenido-binario-en-un-select-en-informix","status":"publish","type":"post","link":"https:\/\/blogs.ua.es\/jpm33\/2017\/07\/06\/obtener-contenido-binario-en-un-select-en-informix\/","title":{"rendered":"Obtener contenido binario en un Select en Informix"},"content":{"rendered":"<h1>Ver hexadecimal en Informix<\/h1>\n<p>En ocasiones resulta interesante poder ver el cotenido de un campo de base de datos en binario (o hexadecimal). Por ejemplo para tema de charsets, o por verificar la forma de almacenarlo.<\/p>\n<p>En infromix tenemos una manera de hacerlo muy sencillo:<\/p>\n<pre>SELECT CAST(nombre_campo AS BYTE)\r\nFROM nombre_tabla\r\nWHERE expresion_condicion;<\/pre>\n<p>Un ejemplo de resultado:<\/p>\n<pre>(nombre_del_campo)                                        \r\n----------------------------------------------------\r\naf  61  6c  75  7a  6a  65  20  64  72  65  77  6e  \r\n52  6f  6c  65  74  79  20  70  6c  65  63  69  6f\r\n<\/pre>\n<p>Espero que resulte \u00fatil.<\/p>\n<h1>Referencias<\/h1>\n<p>&#8211; <strong>CAST Expressions<\/strong>: (visto 6 de julio de 2017) <a href=\"https:\/\/www.ibm.com\/support\/knowledgecenter\/en\/SSGU8G_12.1.0\/com.ibm.sqls.doc\/ids_sqs_0191.htm\">https:\/\/www.ibm.com\/support\/knowledgecenter\/en\/SSGU8G_12.1.0\/com.ibm.sqls.doc\/ids_sqs_0191.htm<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ver hexadecimal en Informix En ocasiones resulta interesante poder ver el cotenido de un campo de base de datos en binario (o hexadecimal). Por ejemplo para tema de charsets, o por verificar la forma de almacenarlo. En infromix tenemos una &hellip; <a href=\"https:\/\/blogs.ua.es\/jpm33\/2017\/07\/06\/obtener-contenido-binario-en-un-select-en-informix\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":3080,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[374,676,236732],"tags":[],"class_list":["post-394","post","type-post","status-publish","format-standard","hentry","category-programacion","category-sin-categoria","category-sql"],"_links":{"self":[{"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/posts\/394","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/users\/3080"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/comments?post=394"}],"version-history":[{"count":2,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/posts\/394\/revisions"}],"predecessor-version":[{"id":397,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/posts\/394\/revisions\/397"}],"wp:attachment":[{"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/media?parent=394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/categories?post=394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/tags?post=394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}