{"id":5209,"date":"2024-10-23T07:31:23","date_gmt":"2024-10-23T07:31:23","guid":{"rendered":"https:\/\/ubiq.co\/tech-blog\/?p=5209"},"modified":"2024-10-23T09:57:52","modified_gmt":"2024-10-23T09:57:52","slug":"how-to-get-character-set-of-mysql-database-or-table-or-column","status":"publish","type":"post","link":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/","title":{"rendered":"How to Get Character Set of MySQL database or table or column"},"content":{"rendered":"\n<p>MySQL allows you to store different kinds of strings and texts in your database columns. There are different data types available for this purpose. But it is equally important to use the right character set for a column. Otherwise, it can lead to errors and slow performance. Character set can be set for a column or table or database. In this article, we will learn how to get character set of table or column or database.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#What_is_Character_Set\" >What is Character Set<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#Default_Character_Set_in_MySQL\" >Default Character Set in MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#How_to_Get_Character_Set_of_MySQL_database_or_table_or_column\" >How to Get Character Set of MySQL database or table or column<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#Character_Sets_in_MySQL\" >Character Sets in MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#Get_Character_Set_of_Database_or_Schema\" >Get Character Set of Database or Schema<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#Get_Character_Set_of_Table\" >Get Character Set of Table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#Get_Character_Set_of_Column\" >Get Character Set of Column<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_Character_Set\"><\/span>What is Character Set<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Character set is the set of characters that are allowed for a given column or table or database. This makes it easy for MySQL database to know beforehand the kind of characters to expect during selection, insertion and update statements, improving performance and avoiding errors. While inserting or modifying data, if one or more characters do not conform to this character set, then MySQL will try to force fit them into the existing character set, or throw an error. <\/p>\n\n\n\n<p>For example, if the character set of a column is set to ASCII, then it will only numerals 0-9, uppercase and lowercase letters, basic punctuation marks and some non-printable control characters. If you try to save a Unicode string in this column, then MySQL will convert it into ASCII format and save it, or give an error. Even if it is saved in ASCII format, it will be unreadable and totally different from your actual data causing confusion. Therefore, it is important to use the right character set for your database, tables and columns.<\/p>\n\n\n\n<p>You will also come across the term &#8216;collation&#8217; while dealing with charsets. Collation is a set of rules to compare a given character with a character set. A character can have multiple collations but a collation will belong to only one charset.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Default_Character_Set_in_MySQL\"><\/span>Default Character Set in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Every database has a character set by default. It is stored in the database variable character_set_database. Each database has a separate value for this variable. You need to switch to your database and access its value to find out its charset. You can find it out by logging into MySQL and running the following queries. Replace &lt;database_name&gt; with your database name.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; use &lt;database_name&gt;<br>mysql&gt; select @@character_set_database;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Get_Character_Set_of_MySQL_database_or_table_or_column\"><\/span>How to Get Character Set of MySQL database or table or column<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>There are several ways to get the character set of MySQL database or table or column. It is important to remember that if the character set for a column is specified, then it will override the character set of the table. If character set of table is specified, then it will override the character set of the database. If the character set of database is specified, then it will override the character set of server.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Character_Sets_in_MySQL\"><\/span>Character Sets in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Each MySQL server supports a number of character sets. You can get this list of available charset using the following command.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT * FROM information_schema.character_sets ORDER BY character_set_name<\/pre>\n\n\n\n<p>You will see the following output.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">| CHARACTER_SET_NAME | DEFAULT_COLLATE_NAME | DESCRIPTION        | MAXLEN |<br>|--------------------|----------------------|--------------------|--------|<br>| armscii8           | armscii8_general_ci  | ARMSCII-8 Armenian |      1 |<br>| ascii              | ascii_general_ci     | US ASCII           |      1 |<br>...<br>...<br>| utf32              | utf32_general_ci     | UTF-32 Unicode     |      4 |<br>| utf8               | utf8_general_ci      | UTF-8 Unicode      |      3 |<br>| utf8mb4            | utf8mb4_0900_ai_ci   | UTF-8 Unicode      |      4 |<\/pre>\n\n\n\n<p>For example, in the above result, utf8mb4 has a MAXLEN of 4, which means each character is represented with 4 bytes.<\/p>\n\n\n\n<p>Every MySQL database has information_schema database that contains all the key information about all databases, tables and columns on your server. You can query this database to obtain the character set of a database, table or column.<\/p>\n\n\n\n<p>In fact, this information is present at different locations of your MySQL server so there are different ways to retrieve it. We have covered a couple of popular ways to get chartset information. You may come across many more.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Get_Character_Set_of_Database_or_Schema\"><\/span>Get Character Set of Database or Schema<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here is the SQL query to obtain the character set of database or schema. Replace &lt;database_name&gt; with the name of your database.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT default_character_set_name FROM information_schema.SCHEMATA <br>WHERE schema_name = \"<strong>&lt;database_name&gt;<\/strong>\";<\/pre>\n\n\n\n<p>The information_schema.SCHEMATA table contains information about all databases on your server, including their charset. This information is present in default_character_set_name column.<\/p>\n\n\n\n<p>Alternatively, you can switch to your database and fetch value of MySQL variable character_set_database.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; USE <strong>&lt;database_name&gt;<\/strong>;<br>mysql&gt; show variables like \"character_set_database\";<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Get_Character_Set_of_Table\"><\/span>Get Character Set of Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>If you want to get the character set of table, then use the following SQL query. Replace &lt;database_name&gt; and &lt;table_name&gt; with the names of your database and tables.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT C.character_set_name FROM information_schema.TABLES T,<br>       information_schema.COLLATION_CHARACTER_SET_APPLICABILITY C<br>WHERE C.collation_name = T.table_collation<br>  AND T.table_schema = \"<strong>&lt;database_name&gt;<\/strong>\"<br>  AND T.table_name = \"<strong>&lt;table_name&gt;<\/strong>\";<\/pre>\n\n\n\n<p>In the above query, we merge information_schema.TABLES and information_schema.COLLATION_CHARACTER_SET_APPLICABILITY tables to obtain a list of database tables along with their key meta information such as charsets. Then we use WHERE clause to filter the charset information about our required database and tables.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Get_Character_Set_of_Column\"><\/span>Get Character Set of Column<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>You can use the following SQL query to get character set of column. Replace &lt;database_name&gt;, &lt;table_name&gt;, &lt;column_name&gt; with the names of your database, table and column respectively.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT character_set_name FROM information_schema.COLUMNS <br>WHERE table_schema = \"<strong>&lt;database_name&gt;<\/strong>\"<br>  AND table_name = \"<strong>&lt;table_name&gt;<\/strong>\"<br>  AND column_name = \"<strong>&lt;column_name&gt;<\/strong>\";<\/pre>\n\n\n\n<p>You can query information_schema.COLUMNS table to obtain the character set information about a specific column.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this article, we have learnt what character sets are, how to get charset for columns, tables, databases and servers. We have also learnt how to alter these character sets. If you are seeing unknown characters in your database column or web pages, then it means you need to change the charset of your data. You can use this information to fix performance issues and errors related to character sets in MySQL. It is important that your database charset is able to handle all characters used by your website\/app. Also, as far as possible, keep it consistent with the charset of your site. Otherwise, you may end up seeing unknown characters on your web pages and\/or your database.<\/p>\n\n\n\n<p>Also read:<\/p>\n\n\n\n<p><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-set-checked-for-checkbox-in-jquery\/\">How to Set Checked for Checkbox in jQuery<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-check-if-file-exists-in-python\/\">How to Check if File Exists in Python<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-merge-two-dictionaries-in-python\/\">How to Merge Two Dictionaries in Python<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Often MySQL database administrators need to get character set of MySQL database, table or column. Here is how to do it.<\/p>\n","protected":false},"author":1,"featured_media":5232,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[324],"tags":[325],"class_list":["post-5209","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-charset"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Get Character Set of MySQL database or table or column - Ubiq BI<\/title>\n<meta name=\"description\" content=\"Often MySQL database administrators need to get character set of MySQL database, table or column. Here is how to do it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Get Character Set of MySQL database or table or column - Ubiq BI\" \/>\n<meta property=\"og:description\" content=\"Often MySQL database administrators need to get character set of MySQL database, table or column. Here is how to do it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/\" \/>\n<meta property=\"og:site_name\" content=\"Ubiq BI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ubiqbi\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-23T07:31:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-23T09:57:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/10\/get-character-set-of-mysql-database-table-column.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"301\" \/>\n\t<meta property=\"og:image:height\" content=\"201\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sreeram Sreenivasan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:site\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sreeram Sreenivasan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/\"},\"author\":{\"name\":\"Sreeram Sreenivasan\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"headline\":\"How to Get Character Set of MySQL database or table or column\",\"datePublished\":\"2024-10-23T07:31:23+00:00\",\"dateModified\":\"2024-10-23T09:57:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/\"},\"wordCount\":959,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/get-character-set-of-mysql-database-table-column.jpg?fit=301%2C201&ssl=1\",\"keywords\":[\"charset\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/\",\"name\":\"How to Get Character Set of MySQL database or table or column - Ubiq BI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/get-character-set-of-mysql-database-table-column.jpg?fit=301%2C201&ssl=1\",\"datePublished\":\"2024-10-23T07:31:23+00:00\",\"dateModified\":\"2024-10-23T09:57:52+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"description\":\"Often MySQL database administrators need to get character set of MySQL database, table or column. Here is how to do it.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/get-character-set-of-mysql-database-table-column.jpg?fit=301%2C201&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/get-character-set-of-mysql-database-table-column.jpg?fit=301%2C201&ssl=1\",\"width\":301,\"height\":201,\"caption\":\"get character set of mysql database table column\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-character-set-of-mysql-database-or-table-or-column\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Get Character Set of MySQL database or table or column\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\",\"name\":\"Ubiq BI\",\"description\":\"Build dashboards &amp; reports in minutes\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\",\"name\":\"Sreeram Sreenivasan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"caption\":\"Sreeram Sreenivasan\"},\"description\":\"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/sreeram-sreenivasan\\\/\"],\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/author\\\/wordpress\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Get Character Set of MySQL database or table or column - Ubiq BI","description":"Often MySQL database administrators need to get character set of MySQL database, table or column. Here is how to do it.","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:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/","og_locale":"en_US","og_type":"article","og_title":"How to Get Character Set of MySQL database or table or column - Ubiq BI","og_description":"Often MySQL database administrators need to get character set of MySQL database, table or column. Here is how to do it.","og_url":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/","og_site_name":"Ubiq BI","article_publisher":"https:\/\/www.facebook.com\/ubiqbi","article_published_time":"2024-10-23T07:31:23+00:00","article_modified_time":"2024-10-23T09:57:52+00:00","og_image":[{"width":301,"height":201,"url":"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/10\/get-character-set-of-mysql-database-table-column.jpg","type":"image\/jpeg"}],"author":"Sreeram Sreenivasan","twitter_card":"summary_large_image","twitter_creator":"@UbiqBI","twitter_site":"@UbiqBI","twitter_misc":{"Written by":"Sreeram Sreenivasan","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#article","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/"},"author":{"name":"Sreeram Sreenivasan","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"headline":"How to Get Character Set of MySQL database or table or column","datePublished":"2024-10-23T07:31:23+00:00","dateModified":"2024-10-23T09:57:52+00:00","mainEntityOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/"},"wordCount":959,"commentCount":0,"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/10\/get-character-set-of-mysql-database-table-column.jpg?fit=301%2C201&ssl=1","keywords":["charset"],"articleSection":["MySQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/","url":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/","name":"How to Get Character Set of MySQL database or table or column - Ubiq BI","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#primaryimage"},"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/10\/get-character-set-of-mysql-database-table-column.jpg?fit=301%2C201&ssl=1","datePublished":"2024-10-23T07:31:23+00:00","dateModified":"2024-10-23T09:57:52+00:00","author":{"@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"description":"Often MySQL database administrators need to get character set of MySQL database, table or column. Here is how to do it.","breadcrumb":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#primaryimage","url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/10\/get-character-set-of-mysql-database-table-column.jpg?fit=301%2C201&ssl=1","contentUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/10\/get-character-set-of-mysql-database-table-column.jpg?fit=301%2C201&ssl=1","width":301,"height":201,"caption":"get character set of mysql database table column"},{"@type":"BreadcrumbList","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-character-set-of-mysql-database-or-table-or-column\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ubiq.co\/tech-blog\/"},{"@type":"ListItem","position":2,"name":"How to Get Character Set of MySQL database or table or column"}]},{"@type":"WebSite","@id":"https:\/\/ubiq.co\/tech-blog\/#website","url":"https:\/\/ubiq.co\/tech-blog\/","name":"Ubiq BI","description":"Build dashboards &amp; reports in minutes","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ubiq.co\/tech-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc","name":"Sreeram Sreenivasan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","caption":"Sreeram Sreenivasan"},"description":"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.","sameAs":["https:\/\/www.linkedin.com\/in\/sreeram-sreenivasan\/"],"url":"https:\/\/ubiq.co\/tech-blog\/author\/wordpress\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/10\/get-character-set-of-mysql-database-table-column.jpg?fit=301%2C201&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/pbGGTT-1m1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/5209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/comments?post=5209"}],"version-history":[{"count":27,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/5209\/revisions"}],"predecessor-version":[{"id":5238,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/5209\/revisions\/5238"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media\/5232"}],"wp:attachment":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media?parent=5209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/categories?post=5209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/tags?post=5209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}