{"id":19667,"date":"2025-02-03T06:55:50","date_gmt":"2025-02-03T06:55:50","guid":{"rendered":"https:\/\/www.pickl.ai\/blog\/?p=19667"},"modified":"2025-02-21T09:38:56","modified_gmt":"2025-02-21T09:38:56","slug":"major-sql-data-types","status":"publish","type":"post","link":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/","title":{"rendered":"Learning Major SQL Data Types"},"content":{"rendered":"\n<p><strong>Summary: <\/strong>Mastering SQL data types improves database efficiency, query performance, and storage management. This guide covers key types like INT, DECIMAL, VARCHAR, DATETIME, BOOLEAN, and specialised data types like BLOB and JSON. Selecting the right type ensures data integrity, accuracy, and optimal performance for data-driven applications and business intelligence.<\/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:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#Introduction\" >Introduction<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#Numeric_Data_Types\" >Numeric Data Types<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#INT_Integer\" >INT (Integer)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#DECIMAL_or_NUMERIC\" >DECIMAL (or NUMERIC)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#FLOAT\" >FLOAT<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#String_Data_Types\" >String Data Types<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#VARCHAR_Variable-Length_Character\" >VARCHAR (Variable-Length Character)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#CHAR_Fixed-Length_Character\" >CHAR (Fixed-Length Character)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#TEXT_Long_Text_Data\" >TEXT (Long Text Data)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#Date_and_Time_Data_Types\" >Date and Time Data Types<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#DATE\" >DATE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#DATETIME\" >DATETIME<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#TIMESTAMP\" >TIMESTAMP<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#Boolean_Data_Type\" >Boolean Data Type<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#BOOLEAN_Data_Type\" >BOOLEAN Data Type<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#BIT_Data_Type\" >BIT Data Type<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#Other_Data_Types\" >Other Data Types<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#BLOB_Binary_Large_Object\" >BLOB (Binary Large Object)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#ENUM_Enumerated_Type\" >ENUM (Enumerated Type)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#JSON_JavaScript_Object_Notation\" >JSON (JavaScript Object Notation)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#In_The_End\" >In The End<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#Frequently_Asked_Questions\" >Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#What_Are_The_Most_Commonly_Used_SQL_Data_Types\" >What Are The Most Commonly Used SQL Data Types?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#How_do_SQL_Numeric_Data_Types_Affect_Performance\" >How do SQL Numeric Data Types Affect Performance?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#When_Should_You_Use_VARCHAR_vs_TEXT_in_SQL\" >When Should You Use VARCHAR vs. TEXT in SQL?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 id=\"introduction\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Introduction\"><\/span><strong>Introduction<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>SQL (Structured Query Language) is the foundation of modern <a href=\"https:\/\/pickl.ai\/blog\/data-management-guide\/\">data management<\/a>. Understanding SQL data types is crucial for effective querying, ensuring optimal storage, retrieval speed, and data integrity. As businesses increasingly rely on data-driven decisions, mastering these data types becomes essential.&nbsp;<\/p>\n\n\n\n<p>The blog aims to explore the significant SQL data types, their applications, and how selecting the right type enhances database performance. The SQL Server Transformation Market is growing rapidly, with industry revenue projected to rise from USD 15.5 billion to USD 30.4 billion by 2029 at a CAGR of <a href=\"https:\/\/www.futuremarketinsights.com\/reports\/sql-server-transformation-market#:~:text=SQL%20Server%20Transformation%20Market%20Outlook,by%20the%20end%20of%202029.\" rel=\"nofollow\">10.1%<\/a>.<\/p>\n\n\n\n<p><strong>Key Takeaways<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SQL data types impact storage, performance, and data integrity in databases.<\/li>\n\n\n\n<li>Numeric types like INT, DECIMAL, and FLOAT offer different precision and efficiency levels.<\/li>\n\n\n\n<li>String types such as VARCHAR, CHAR, and TEXT optimize storage based on data length.<\/li>\n\n\n\n<li>Date\/time types like DATE, DATETIME, and TIMESTAMP track and store time-related data.<\/li>\n\n\n\n<li>Choosing the right SQL data type improves query speed, data accuracy, and overall database performance.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"numeric-data-types\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Numeric_Data_Types\"><\/span><strong>Numeric Data Types<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Numeric data types in <a href=\"https:\/\/pickl.ai\/blog\/introduction-to-sql-for-data-science\/\">SQL<\/a> are essential for storing numeric values. They allow us to store whole numbers and numbers with decimal places, making it crucial to choose the correct type to ensure data accuracy and optimal performance. Here, we will explore the most commonly used numeric types: INT, DECIMAL, and FLOAT.<\/p>\n\n\n\n<h3 id=\"int-integer\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"INT_Integer\"><\/span><strong>INT (Integer)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The INT type is used for storing whole numbers, either positive or negative, without any decimal places. It is ideal for counting items, such as the number of orders or users.&nbsp;<\/p>\n\n\n\n<p>Depending on the database system, the range of INT can vary, but it typically supports values from -2,147,483,648 to 2,147,483,647. Use INT when you need to store large numbers, but do not require decimal precision.<\/p>\n\n\n\n<h3 id=\"decimal-or-numeric\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"DECIMAL_or_NUMERIC\"><\/span><strong>DECIMAL (or NUMERIC)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The DECIMAL type is designed to store fixed-point numbers with exact precision, especially useful for financial calculations where rounding errors are unacceptable. You can specify the total number of digits and the number of digits after the decimal point.&nbsp;<\/p>\n\n\n\n<p>For example, DECIMAL(10, 2) would allow for numbers up to 10 digits, with 2 digits after the decimal point.<\/p>\n\n\n\n<h3 id=\"float\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"FLOAT\"><\/span><strong>FLOAT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The FLOAT type is used for storing approximate numeric values that may require precision but not an exact value. It is commonly used for scientific calculations or measurements where slight rounding errors are tolerable. Unlike DECIMAL, FLOAT stores data in binary form, making it less precise but more flexible for large ranges of values.<\/p>\n\n\n\n<p>Choosing between these numeric types depends on the precision, range, and performance your application requires.<\/p>\n\n\n\n<h2 id=\"string-data-types\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"String_Data_Types\"><\/span><strong>String Data Types<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcvdSyemATZ13E3Bo2OqsLQVJhSi807ApoQI-c_6hjVgfnbfSs6w5u9XX0-kfS3xGXRcskKBYP4EfVmshmKA1yeUcYlvTZZ0VxamgYEhsl_zpyIMCmAfHxCd6f4eopPJw_px8JMzQ?key=Z_UaIYfGqDwh4Hdyjm46aHiz\" alt=\"String data types\"\/><\/figure>\n\n\n\n<p>String data types in SQL are used to store textual data. Choosing the appropriate string type is crucial for efficient storage and retrieval, as different types have varying storage requirements and performance implications. The most commonly used string types are VARCHAR, CHAR, and TEXT, each with specific use cases.<\/p>\n\n\n\n<h3 id=\"varchar-variable-length-character\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"VARCHAR_Variable-Length_Character\"><\/span><strong>VARCHAR (Variable-Length Character)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The VARCHAR type is used to store variable-length strings. It is ideal when the length of the data can vary significantly, such as in names or email addresses.&nbsp;<\/p>\n\n\n\n<p>The main advantage of VARCHAR is that it only uses as much storage as necessary for the actual string, plus an additional byte for length storage. This makes it more storage-efficient for strings that differ significantly in length.<\/p>\n\n\n\n<h3 id=\"char-fixed-length-character\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"CHAR_Fixed-Length_Character\"><\/span><strong>CHAR (Fixed-Length Character)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The CHAR type is designed to store fixed-length strings. It is useful when the length of the data is predictable or consistent, such as storing country codes or fixed-format IDs.&nbsp;<\/p>\n\n\n\n<p>Even if the data is shorter than the specified length, CHAR will still pad the remaining space with blank characters, making it less storage-efficient than VARCHAR for variable-length strings.<\/p>\n\n\n\n<h3 id=\"text-long-text-data\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"TEXT_Long_Text_Data\"><\/span><strong>TEXT (Long Text Data)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The TEXT type stores long strings or large blocks of text, such as descriptions, articles, or comments. It does not have a predefined length limit (though it may vary by <a href=\"https:\/\/pickl.ai\/blog\/database-vs-data-warehouse\/\">database system<\/a>), making it suitable for storing data of significant size.&nbsp;<\/p>\n\n\n\n<p>However, due to its size, TEXT requires more storage and may perform slower in some queries.<\/p>\n\n\n\n<p>Selecting the right string type depends on the length and nature of the data you intend to store, impacting performance and storage efficiency.<\/p>\n\n\n\n<h2 id=\"date-and-time-data-types\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Date_and_Time_Data_Types\"><\/span><strong>Date and Time Data Types<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In SQL, accurately handling date and time <a href=\"https:\/\/pickl.ai\/blog\/difference-between-data-and-information\/\">data<\/a> is crucial for applications that track events, transactions, or logs. SQL provides several date and time data types, each serving a specific purpose. Understanding the differences between DATE, DATETIME, and TIMESTAMP is essential for effectively storing and manipulating time-related data.<\/p>\n\n\n\n<h3 id=\"date\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"DATE\"><\/span><strong>DATE<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The DATE type only stores date values, without any time component. It is ideal for situations where only the day, month, and year are required, such as birthdates or event dates. The format typically follows YYYY-MM-DD. For instance, 2025-01-29 would be a valid DATE value.<\/p>\n\n\n\n<h3 id=\"datetime\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"DATETIME\"><\/span><strong>DATETIME<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The DATETIME type stores the date and the time down to fractions of a second. This is useful when capturing the exact moment an event occurs, including hours, minutes, seconds, and milliseconds. The format for DATETIME is YYYY-MM-DD HH:MM:SS. For example, 2025-01-29 14:30:00 represents both the date and time.<\/p>\n\n\n\n<h3 id=\"timestamp\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"TIMESTAMP\"><\/span><strong>TIMESTAMP<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The TIMESTAMP type also stores the date and time, but it is unique in that it is typically used to represent the number of seconds since January 1, 1970, in UTC time.&nbsp;<\/p>\n\n\n\n<p>It is commonly used for tracking changes to records automatically (e.g., in audit logs or versioning systems) and can convert between time zones.<\/p>\n\n\n\n<p>Each of these types is suited to different needs depending on the detail and precision required for the time-related data.<\/p>\n\n\n\n<h2 id=\"boolean-data-type\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Boolean_Data_Type\"><\/span><strong>Boolean Data Type<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfl9cKnkdBnVhXzKsu32fUugOP8ZcrKvvZklnwbqmIJr9thDu4uJvNxYmSpvd2YYEUOU8UVDKSylnn8f3wxJcRxd1XsrRy7vTudnrHaniJZGsDsclW9c-hHM-k92hzUkLYb2-KkQQ?key=Z_UaIYfGqDwh4Hdyjm46aHiz\" alt=\"BOOLEAN data type.\"\/><\/figure>\n\n\n\n<p>The BOOLEAN or BIT data type represents binary values, typically for logical true\/false or yes\/no conditions. This type is crucial for handling database decisions, flags, and binary states. While both BOOLEAN and BIT serve similar purposes, understanding how they function and are represented in SQL is key to using them effectively.<\/p>\n\n\n\n<h3 id=\"boolean-data-type-2\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"BOOLEAN_Data_Type\"><\/span><strong>BOOLEAN Data Type<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The BOOLEAN data type stores true\/false values in most SQL systems. It simplifies logical operations and is typically used for fields that require a binary state, such as whether a user is active or inactive or if a product is in stock or out of stock.&nbsp;<\/p>\n\n\n\n<p>Some database systems, like PostgreSQL, directly support the BOOLEAN type, allowing TRUE or FALSE values to be stored easily.<\/p>\n\n\n\n<h3 id=\"bit-data-type\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"BIT_Data_Type\"><\/span><strong>BIT Data Type<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The <strong>BIT<\/strong> type stores binary values, often used in systems like MySQL or SQL Server. A BIT column can hold 0 or 1, where 0 represents false, and 1 means true. While it offers the same logical functionality as BOOLEAN, it typically uses less storage space.&nbsp;<\/p>\n\n\n\n<p>For example, SQL Server stores a single bit per value rather than a full boolean, which may save space when dealing with large datasets.<\/p>\n\n\n\n<p>Using BOOLEAN or BIT effectively ensures that your data accurately reflects binary conditions and allows for efficient querying and logical operations.<\/p>\n\n\n\n<h2 id=\"other-data-types\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Other_Data_Types\"><\/span><strong>Other Data Types<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>While SQL primarily focuses on standard numeric, string, and date types, it also supports special data types that cater to specific use cases. These include BLOB, ENUM, and JSON\u2014each offering unique functionality suited for various data storage and retrieval needs.<\/p>\n\n\n\n<h3 id=\"blob-binary-large-object\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"BLOB_Binary_Large_Object\"><\/span><strong>BLOB (Binary Large Object)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>BLOB is a data type for storing large binary data such as images, audio files, and multimedia content. Depending on the database system, it can hold up to several gigabytes of data. BLOB is essential when dealing with non-textual content, allowing applications to store large amounts of raw data efficiently.&nbsp;<\/p>\n\n\n\n<p>Unlike text fields, which handle character data, BLOB stores binary information, making it ideal for media-heavy applications.<\/p>\n\n\n\n<h3 id=\"enum-enumerated-type\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ENUM_Enumerated_Type\"><\/span><strong>ENUM (Enumerated Type)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The ENUM data type allows you to define a list of predefined values for a column.&nbsp;<\/p>\n\n\n\n<p>For example, if you have a &#8220;status&#8221; column in a task management system, you could limit its values to &#8216;Pending,&#8217; &#8216;In Progress,&#8217; and &#8216;Completed.&#8217; ENUM ensures data consistency by restricting input to these values, making it an excellent choice for columns requiring a fixed set of options.<\/p>\n\n\n\n<h3 id=\"json-javascript-object-notation\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"JSON_JavaScript_Object_Notation\"><\/span><strong>JSON (JavaScript Object Notation)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The <strong>JSON<\/strong> type stores JSON-formatted data, widely used for transmitting data in web applications. It allows for flexible and hierarchical storage of complex, nested structures like arrays and objects.&nbsp;<\/p>\n\n\n\n<p>JSON is beneficial when dealing with semi-structured data or integrating with APIs that return data in this format, making it a valuable tool in modern applications requiring dynamic and flexible data storage.<\/p>\n\n\n\n<h2 id=\"in-the-end\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"In_The_End\"><\/span><strong>In The End<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Understanding SQL data types is fundamental for optimising database performance, ensuring data integrity, and improving query efficiency. Selecting the correct data type\u2014whether numeric, string, date\/time, Boolean, or specialised\u2014affects storage, retrieval speed, and overall system performance. Businesses relying on data-driven decisions benefit from structured and efficient databases.&nbsp;<\/p>\n\n\n\n<p>Choosing INT, DECIMAL, VARCHAR, DATETIME, or other appropriate types ensures accuracy and efficiency in data handling. Mastering SQL data types becomes crucial for database professionals, analysts, and developers as data management evolves. By leveraging the right types, organisations can optimise data storage, streamline operations, and enhance application performance in modern databases.<\/p>\n\n\n\n<h2 id=\"frequently-asked-questions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span><strong>Frequently Asked Questions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"what-are-the-most-commonly-used-sql-data-types\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_Are_The_Most_Commonly_Used_SQL_Data_Types\"><\/span><strong>What Are The Most Commonly Used SQL Data Types?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The most commonly used SQL data types include INT (for whole numbers), DECIMAL (for precise numeric values), VARCHAR (for variable-length text), DATE\/DATETIME (for time-related data), and BOOLEAN (for true\/false values). Choosing the right type ensures optimal storage, accuracy, and database performance.<\/p>\n\n\n\n<h3 id=\"how-do-sql-numeric-data-types-affect-performance\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_do_SQL_Numeric_Data_Types_Affect_Performance\"><\/span><strong>How do SQL Numeric Data Types Affect Performance?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>SQL numeric data types impact storage and computation efficiency. INT is best for whole numbers, DECIMAL ensures precision in financial data, and FLOAT handles large numerical ranges with minor precision loss. Proper selection minimises storage costs and enhances query execution speed.<\/p>\n\n\n\n<h3 id=\"when-should-you-use-varchar-vs-text-in-sql\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"When_Should_You_Use_VARCHAR_vs_TEXT_in_SQL\"><\/span><strong>When Should You Use VARCHAR vs. TEXT in SQL?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Use VARCHAR for short, variable-length text fields (e.g., names, emails) since it uses minimal storage. TEXT is ideal for long-form content (e.g., descriptions, articles) but may have slower performance in queries. Choosing the right type optimises database efficiency and retrieval speed.<\/p>\n","protected":false},"excerpt":{"rendered":"Explore major SQL data types like INT, VARCHAR, DATETIME &#038; more to optimise storage and performance.\n","protected":false},"author":27,"featured_media":19668,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[613],"tags":[3760],"ppma_author":[2217,2605],"class_list":{"0":"post-19667","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sql","8":"tag-sql-data-types"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Data Types in SQL: A Comprehensive Guide with Examples<\/title>\n<meta name=\"description\" content=\"The essential SQL data types\u2014numeric, string, date\/time\u2014to optimise storage, enhance query performance, and ensure database efficiency.\" \/>\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.pickl.ai\/blog\/major-sql-data-types\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learning Major SQL Data Types\" \/>\n<meta property=\"og:description\" content=\"The essential SQL data types\u2014numeric, string, date\/time\u2014to optimise storage, enhance query performance, and ensure database efficiency.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/\" \/>\n<meta property=\"og:site_name\" content=\"Pickl.AI\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-03T06:55:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-21T09:38:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/02\/image1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Julie Bowie, Anshul Jain\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julie Bowie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/\"},\"author\":{\"name\":\"Julie Bowie\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/c4ff9404600a51d9924b7d4356505a40\"},\"headline\":\"Learning Major SQL Data Types\",\"datePublished\":\"2025-02-03T06:55:50+00:00\",\"dateModified\":\"2025-02-21T09:38:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/\"},\"wordCount\":1687,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image1.png\",\"keywords\":[\"SQL data types\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/\",\"name\":\"Data Types in SQL: A Comprehensive Guide with Examples\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image1.png\",\"datePublished\":\"2025-02-03T06:55:50+00:00\",\"dateModified\":\"2025-02-21T09:38:56+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/c4ff9404600a51d9924b7d4356505a40\"},\"description\":\"The essential SQL data types\u2014numeric, string, date\\\/time\u2014to optimise storage, enhance query performance, and ensure database efficiency.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image1.png\",\"contentUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image1.png\",\"width\":800,\"height\":500,\"caption\":\"Learning major SQL data types.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/major-sql-data-types\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/category\\\/sql\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Learning Major SQL Data Types\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\",\"name\":\"Pickl.AI\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/c4ff9404600a51d9924b7d4356505a40\",\"name\":\"Julie Bowie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g6d567bb101286f6a3fd640329347e093\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g\",\"caption\":\"Julie Bowie\"},\"description\":\"I am Julie Bowie a data scientist with a specialization in machine learning. I have conducted research in the field of language processing and has published several papers in reputable journals.\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/author\\\/juliebowie\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Types in SQL: A Comprehensive Guide with Examples","description":"The essential SQL data types\u2014numeric, string, date\/time\u2014to optimise storage, enhance query performance, and ensure database efficiency.","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.pickl.ai\/blog\/major-sql-data-types\/","og_locale":"en_US","og_type":"article","og_title":"Learning Major SQL Data Types","og_description":"The essential SQL data types\u2014numeric, string, date\/time\u2014to optimise storage, enhance query performance, and ensure database efficiency.","og_url":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/","og_site_name":"Pickl.AI","article_published_time":"2025-02-03T06:55:50+00:00","article_modified_time":"2025-02-21T09:38:56+00:00","og_image":[{"width":800,"height":500,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/02\/image1.png","type":"image\/png"}],"author":"Julie Bowie, Anshul Jain","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Julie Bowie","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#article","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/"},"author":{"name":"Julie Bowie","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/c4ff9404600a51d9924b7d4356505a40"},"headline":"Learning Major SQL Data Types","datePublished":"2025-02-03T06:55:50+00:00","dateModified":"2025-02-21T09:38:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/"},"wordCount":1687,"commentCount":0,"image":{"@id":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/02\/image1.png","keywords":["SQL data types"],"articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/","url":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/","name":"Data Types in SQL: A Comprehensive Guide with Examples","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#primaryimage"},"image":{"@id":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/02\/image1.png","datePublished":"2025-02-03T06:55:50+00:00","dateModified":"2025-02-21T09:38:56+00:00","author":{"@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/c4ff9404600a51d9924b7d4356505a40"},"description":"The essential SQL data types\u2014numeric, string, date\/time\u2014to optimise storage, enhance query performance, and ensure database efficiency.","breadcrumb":{"@id":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#primaryimage","url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/02\/image1.png","contentUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/02\/image1.png","width":800,"height":500,"caption":"Learning major SQL data types."},{"@type":"BreadcrumbList","@id":"https:\/\/www.pickl.ai\/blog\/major-sql-data-types\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pickl.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL","item":"https:\/\/www.pickl.ai\/blog\/category\/sql\/"},{"@type":"ListItem","position":3,"name":"Learning Major SQL Data Types"}]},{"@type":"WebSite","@id":"https:\/\/www.pickl.ai\/blog\/#website","url":"https:\/\/www.pickl.ai\/blog\/","name":"Pickl.AI","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pickl.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/c4ff9404600a51d9924b7d4356505a40","name":"Julie Bowie","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g6d567bb101286f6a3fd640329347e093","url":"https:\/\/secure.gravatar.com\/avatar\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g","caption":"Julie Bowie"},"description":"I am Julie Bowie a data scientist with a specialization in machine learning. I have conducted research in the field of language processing and has published several papers in reputable journals.","url":"https:\/\/www.pickl.ai\/blog\/author\/juliebowie\/"}]}},"jetpack_featured_media_url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/02\/image1.png","authors":[{"term_id":2217,"user_id":27,"is_guest":0,"slug":"juliebowie","display_name":"Julie Bowie","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g","first_name":"Julie","user_url":"","last_name":"Bowie","description":"I am Julie Bowie a data scientist with a specialization in machine learning. I have conducted research in the field of language processing and has published several papers in reputable journals."},{"term_id":2605,"user_id":43,"is_guest":0,"slug":"anshuljain","display_name":"Anshul Jain","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/07\/avatar_user_43_1721992955-96x96.jpeg","first_name":"Anshul","user_url":"","last_name":"Jain","description":"Anshul Jain expertise lies in Predictive Modelling and Segmentation of data. Recently graduated from NSUT, Delhi in Instrumentation and Control Engineering. He has a keen interest in studying the Stock Market."}],"_links":{"self":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/19667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/comments?post=19667"}],"version-history":[{"count":2,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/19667\/revisions"}],"predecessor-version":[{"id":19672,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/19667\/revisions\/19672"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media\/19668"}],"wp:attachment":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media?parent=19667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/categories?post=19667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/tags?post=19667"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/ppma_author?post=19667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}