{"id":753,"date":"2020-07-24T10:46:10","date_gmt":"2020-07-24T08:46:10","guid":{"rendered":"http:\/\/rootfan.com\/?p=753"},"modified":"2022-04-03T23:59:04","modified_gmt":"2022-04-03T21:59:04","slug":"comprobar-el-juego-de-caracteres-de-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/check-oracle-characterset\/","title":{"rendered":"C\u00f3mo comprobar el juego de caracteres de Oracle Database"},"content":{"rendered":"<p>Muchas veces es necesario validar el juego de caracteres de la base de datos Oracle, quiz\u00e1s porque se trata de una base de datos Oracle antigua que no dispon\u00eda de UTF8 (que es el juego de caracteres recomendado) o quiz\u00e1s porque alguien cre\u00f3 la base de datos con un juego de caracteres diferente por un motivo determinado...<\/p>\n\n\n\n<p>En cualquier caso, aqu\u00ed tienes c\u00f3mo puedes comprobar el juego de caracteres de la base de datos Oracle:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">select *\nfrom NLS_DATABASE_PARAMETERS\nwhere parameter='NLS_CHARACTERSET';<\/pre><\/pre>","protected":false},"excerpt":{"rendered":"<p>Muchas veces necesitas validar el juego de caracteres de la base de datos Oracle, quiz\u00e1s porque es una base de datos Oracle antigua que no ten\u00eda UTF8 (que es el juego de caracteres recomendado) o quiz\u00e1s porque alguien cre\u00f3 la base de datos con un juego de caracteres diferente por una raz\u00f3n determinada... En cualquier caso, as\u00ed es como puedes comprobar el juego de caracteres de la base de datos Oracle: select ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/es\/check-oracle-characterset\/\" class=\"more-link\">Seguir leyendo<span class=\"screen-reader-text\"> \"C\u00f3mo comprobar el juego de caracteres de la base de datos Oracle\"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":2908,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"","rank_math_title":"","rank_math_description":"Learn how to check the character set of your Oracle database and ensure proper data handling and compatibility.","rank_math_robots":null,"rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[31],"tags":[39,40],"class_list":["post-753","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-charset","tag-utf8"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-2150347.jpeg?fit=1880%2C1253&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/comments?post=753"}],"version-history":[{"count":5,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/753\/revisions"}],"predecessor-version":[{"id":2910,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/753\/revisions\/2910"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2908"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}