{"id":900,"date":"2013-05-08T22:52:42","date_gmt":"2013-05-09T02:52:42","guid":{"rendered":"https:\/\/gonzalo.aro.cl\/blog\/?p=900"},"modified":"2013-05-08T23:29:23","modified_gmt":"2013-05-09T03:29:23","slug":"encontrar-en-moodle-oracle-un-texto-dentro-de-columnas-codificadas-en-base64","status":"publish","type":"post","link":"https:\/\/gonzalo.aro.cl\/blog\/2013\/05\/08\/encontrar-en-moodle-oracle-un-texto-dentro-de-columnas-codificadas-en-base64\/","title":{"rendered":"Encontrar en Moodle (Oracle) un texto dentro de columnas codificadas en Base64"},"content":{"rendered":"<p>Una de las cosas que hace moodle que en las columnas donde guarda texto, para evitar ciertas problematicas que solo ellos conocen, codifican el dato en Base64. Esto implica que en algunos casos el texto de la columna se va a ver de la siguiente forma (mirar columna CONFIGDATA):<\/p>\n<p><a href=\"https:\/\/gonzalo.aro.cl\/blog\/wp-content\/uploads\/2013\/05\/moodle_blockinstances1.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/gonzalo.aro.cl\/blog\/wp-content\/uploads\/2013\/05\/moodle_blockinstances1-300x88.gif\" alt=\"moodle_blockinstances\" width=\"300\" height=\"88\" class=\"aligncenter size-medium wp-image-903\" \/><\/a><\/p>\n<p>Una de las maneras de decodificar directamente en Oracle estas columnas es as\u00ed (un ejemplo con la tabla m_block de moodle):<\/p>\n<pre class=\"brush: sql\">\r\nselect id, utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw( configdata))) \r\nfrom m_block_instances \r\nwhere blockname = 'html' \r\nand utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw( configdata))) like '%algun texto%'\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Una de las cosas que hace moodle que en las columnas donde guarda texto, para evitar ciertas problematicas que solo ellos conocen, codifican el dato en Base64. Esto implica que en algunos casos el texto de la columna se va a ver de la siguiente forma (mirar columna CONFIGDATA): Una de las maneras de decodificar [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,54,58,57,4,48,9,56,55],"tags":[],"class_list":["post-900","post","type-post","status-publish","format-standard","hentry","category-base-de-datos","category-base64","category-base64_decode","category-cast_to_varchar2","category-desarrollo","category-moodle","category-oracle","category-utl_encode","category-utl_raw"],"_links":{"self":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/900"}],"collection":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/comments?post=900"}],"version-history":[{"count":5,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/900\/revisions"}],"predecessor-version":[{"id":907,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/900\/revisions\/907"}],"wp:attachment":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/media?parent=900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/categories?post=900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/tags?post=900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}