{"id":10910,"date":"2024-03-14T12:59:45","date_gmt":"2024-03-14T12:59:45","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/"},"modified":"2025-08-04T05:23:43","modified_gmt":"2025-08-04T05:23:43","slug":"how-to-view-the-database-encoding-in-db2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/","title":{"rendered":"Check DB2 Database Encoding"},"content":{"rendered":"

In DB2, you can view the database encoding using the following command.<\/p>\n

    \n
  1. Log in to the DB2 database server using the command line interface.<\/li>\n
  2. Execute the following SQL statement to view the current database encoding:<\/li>\n<\/ol>\n
    SELECT<\/span> CODEPAGE, TERRITORY, COLLATE<\/span> FROM<\/span> SYSIBMADM.ENV_DATABASE;\r\n<\/code><\/pre>\n
    This SQL statement will retrieve encoding information for the current database, including CODEPAGE, TERRITORY, and COLLATE. By examining this information, you can understand the current encoding settings of the database.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In DB2, you can view the database encoding using the following command. Log in to the DB2 database server using the command line interface. Execute the following SQL statement to view the current database encoding: SELECT CODEPAGE, TERRITORY, COLLATE FROM SYSIBMADM.ENV_DATABASE; This SQL statement will retrieve encoding information for the current database, including CODEPAGE, TERRITORY, […]<\/p>\n","protected":false},"author":14,"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":[13816,1093,935,13815,13817],"class_list":["post-10910","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-codepage","tag-database-encoding","tag-db2","tag-sql-command","tag-territory"],"yoast_head":"\nCheck DB2 Database Encoding - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"View DB2 database encoding with SQL. Get CODEPAGE, TERRITORY, COLLATE settings instantly.\" \/>\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-to-view-the-database-encoding-in-db2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Check DB2 Database Encoding\" \/>\n<meta property=\"og:description\" content=\"View DB2 database encoding with SQL. Get CODEPAGE, TERRITORY, COLLATE settings instantly.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/\" \/>\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:59:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T05:23:43+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\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=\"Noah Thompson\" \/>\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-to-view-the-database-encoding-in-db2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"Check DB2 Database Encoding\",\"datePublished\":\"2024-03-14T12:59:45+00:00\",\"dateModified\":\"2025-08-04T05:23:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/\"},\"wordCount\":69,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"CODEPAGE\",\"database encoding\",\"DB2\",\"SQL command\",\"TERRITORY\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/\",\"name\":\"Check DB2 Database Encoding - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T12:59:45+00:00\",\"dateModified\":\"2025-08-04T05:23:43+00:00\",\"description\":\"View DB2 database encoding with SQL. Get CODEPAGE, TERRITORY, COLLATE settings instantly.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Check DB2 Database Encoding\"}]},{\"@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\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Check DB2 Database Encoding - Blog - Silicon Cloud","description":"View DB2 database encoding with SQL. Get CODEPAGE, TERRITORY, COLLATE settings instantly.","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-to-view-the-database-encoding-in-db2\/","og_locale":"en_US","og_type":"article","og_title":"Check DB2 Database Encoding","og_description":"View DB2 database encoding with SQL. Get CODEPAGE, TERRITORY, COLLATE settings instantly.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T12:59:45+00:00","article_modified_time":"2025-08-04T05:23:43+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"Check DB2 Database Encoding","datePublished":"2024-03-14T12:59:45+00:00","dateModified":"2025-08-04T05:23:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/"},"wordCount":69,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["CODEPAGE","database encoding","DB2","SQL command","TERRITORY"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/","name":"Check DB2 Database Encoding - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T12:59:45+00:00","dateModified":"2025-08-04T05:23:43+00:00","description":"View DB2 database encoding with SQL. Get CODEPAGE, TERRITORY, COLLATE settings instantly.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-database-encoding-in-db2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Check DB2 Database Encoding"}]},{"@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\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10910","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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=10910"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10910\/revisions"}],"predecessor-version":[{"id":154677,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10910\/revisions\/154677"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=10910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=10910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=10910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}