{"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":"verifier-le-jeu-de-caracteres-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/check-oracle-characterset\/","title":{"rendered":"Comment v\u00e9rifier le jeu de caract\u00e8res de la base de donn\u00e9es Oracle"},"content":{"rendered":"<p>Il est souvent n\u00e9cessaire de valider le jeu de caract\u00e8res de la base de donn\u00e9es Oracle, soit parce qu'il s'agit d'une ancienne base de donn\u00e9es Oracle qui ne disposait pas de UTF8 (qui est le jeu de caract\u00e8res recommand\u00e9), soit parce que quelqu'un a cr\u00e9\u00e9 la base de donn\u00e9es avec un jeu de caract\u00e8res diff\u00e9rent pour une raison donn\u00e9e...<\/p>\n\n\n\n<p>Quoi qu'il en soit, voici comment v\u00e9rifier le jeu de caract\u00e8res de la base de donn\u00e9es Oracle :<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">s\u00e9lectionner *\nfrom NLS_DATABASE_PARAMETERS\no\u00f9 parameter='NLS_CHARACTERSET' ;<\/pre><\/pre>","protected":false},"excerpt":{"rendered":"<p>Il est souvent n\u00e9cessaire de valider le jeu de caract\u00e8res de la base de donn\u00e9es Oracle, peut-\u00eatre parce qu'il s'agit d'une ancienne base de donn\u00e9es Oracle qui n'avait pas UTF8 (qui est le jeu de caract\u00e8res recommand\u00e9) ou peut-\u00eatre parce que quelqu'un a cr\u00e9\u00e9 la base de donn\u00e9es avec un jeu de caract\u00e8res diff\u00e9rent pour une raison donn\u00e9e... Quoi qu'il en soit, voici comment vous pouvez v\u00e9rifier le jeu de caract\u00e8res de la base de donn\u00e9es Oracle : select ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/fr\/check-oracle-characterset\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de \" Comment v\u00e9rifier le jeu de caract\u00e8res de la base de donn\u00e9es 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\/fr\/wp-json\/wp\/v2\/posts\/753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=753"}],"version-history":[{"count":5,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/753\/revisions"}],"predecessor-version":[{"id":2910,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/753\/revisions\/2910"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2908"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}