{"id":10650,"date":"2024-03-14T12:29:24","date_gmt":"2024-03-14T12:29:24","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/"},"modified":"2025-08-04T02:10:04","modified_gmt":"2025-08-04T02:10:04","slug":"how-can-the-font-encoding-format-be-adjusted-in-pl-sql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/","title":{"rendered":"Adjust Font Encoding in PL\/SQL"},"content":{"rendered":"<p>In PL\/SQL, the NLS_LANG parameter can be used to adjust the font encoding format. This parameter controls the language and character set of the database session, including the character set name and sorting rules. You can adjust the font encoding format in PL\/SQL by following these steps:<\/p>\n<ol>\n<li>Open PL\/SQL tools such as SQL*Plus or SQL Developer.<\/li>\n<li>The setting for language and character encoding in Oracle databases is known as NLS_LANG.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">FROM<\/span> nls_session_parameters <span class=\"hljs-keyword\">WHERE<\/span> <span class=\"hljs-keyword\">parameter<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'NLS_LANGUAGE'<\/span> <span class=\"hljs-keyword\">OR<\/span> <span class=\"hljs-keyword\">parameter<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'NLS_TERRITORY'<\/span> <span class=\"hljs-keyword\">OR<\/span> <span class=\"hljs-keyword\">parameter<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'NLS_CHARACTERSET'<\/span>;\r\n<\/code><\/pre>\n<ol>\n<li>NLS_LANG setting<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">ALTER<\/span> SESSION <span class=\"hljs-keyword\">SET<\/span> NLS_LANGUAGE <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'AMERICAN'<\/span>;\r\n<span class=\"hljs-keyword\">ALTER<\/span> SESSION <span class=\"hljs-keyword\">SET<\/span> NLS_TERRITORY <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'AMERICA'<\/span>;\r\n<span class=\"hljs-keyword\">ALTER<\/span> SESSION <span class=\"hljs-keyword\">SET<\/span> NLS_CHARACTERSET <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'UTF8'<\/span>;\r\n<\/code><\/pre>\n<ol>\n<li>Language settings for Oracle databases<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">FROM<\/span> nls_session_parameters <span class=\"hljs-keyword\">WHERE<\/span> <span class=\"hljs-keyword\">parameter<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'NLS_LANGUAGE'<\/span> <span class=\"hljs-keyword\">OR<\/span> <span class=\"hljs-keyword\">parameter<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'NLS_TERRITORY'<\/span> <span class=\"hljs-keyword\">OR<\/span> <span class=\"hljs-keyword\">parameter<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'NLS_CHARACTERSET'<\/span>;\r\n<\/code><\/pre>\n<p>By following the above steps, you can adjust the font encoding format in PL\/SQL to meet the required character set and encoding standards.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In PL\/SQL, the NLS_LANG parameter can be used to adjust the font encoding format. This parameter controls the language and character set of the database session, including the character set name and sorting rules. You can adjust the font encoding format in PL\/SQL by following these steps: Open PL\/SQL tools such as SQL*Plus or SQL [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[724,13399,13400,813,321],"class_list":["post-10650","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-character-set","tag-font-encoding","tag-nls_lang","tag-oracle-database","tag-pl-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Adjust Font Encoding in PL\/SQL - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to adjust font encoding in PL\/SQL using NLS_LANG. Complete guide to setting character encoding in Oracle PL\/SQL tools.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Adjust Font Encoding in PL\/SQL\" \/>\n<meta property=\"og:description\" content=\"Learn how to adjust font encoding in PL\/SQL using NLS_LANG. Complete guide to setting character encoding in Oracle PL\/SQL tools.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T12:29:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T02:10:04+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jackson Davis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"Adjust Font Encoding in PL\/SQL\",\"datePublished\":\"2024-03-14T12:29:24+00:00\",\"dateModified\":\"2025-08-04T02:10:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/\"},\"wordCount\":114,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Character Set\",\"Font Encoding\",\"NLS_LANG\",\"Oracle database\",\"PL\/SQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/\",\"name\":\"Adjust Font Encoding in PL\/SQL - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T12:29:24+00:00\",\"dateModified\":\"2025-08-04T02:10:04+00:00\",\"description\":\"Learn how to adjust font encoding in PL\/SQL using NLS_LANG. Complete guide to setting character encoding in Oracle PL\/SQL tools.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adjust Font Encoding in PL\/SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Adjust Font Encoding in PL\/SQL - Blog - Silicon Cloud","description":"Learn how to adjust font encoding in PL\/SQL using NLS_LANG. Complete guide to setting character encoding in Oracle PL\/SQL tools.","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:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/","og_locale":"en_US","og_type":"article","og_title":"Adjust Font Encoding in PL\/SQL","og_description":"Learn how to adjust font encoding in PL\/SQL using NLS_LANG. Complete guide to setting character encoding in Oracle PL\/SQL tools.","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T12:29:24+00:00","article_modified_time":"2025-08-04T02:10:04+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"Adjust Font Encoding in PL\/SQL","datePublished":"2024-03-14T12:29:24+00:00","dateModified":"2025-08-04T02:10:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/"},"wordCount":114,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Character Set","Font Encoding","NLS_LANG","Oracle database","PL\/SQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/","name":"Adjust Font Encoding in PL\/SQL - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T12:29:24+00:00","dateModified":"2025-08-04T02:10:04+00:00","description":"Learn how to adjust font encoding in PL\/SQL using NLS_LANG. Complete guide to setting character encoding in Oracle PL\/SQL tools.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-the-font-encoding-format-be-adjusted-in-pl-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Adjust Font Encoding in PL\/SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=10650"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10650\/revisions"}],"predecessor-version":[{"id":154416,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10650\/revisions\/154416"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=10650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=10650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=10650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}