{"id":1609,"date":"2023-05-23T04:18:43","date_gmt":"2023-05-23T04:18:43","guid":{"rendered":"https:\/\/itnotes.apjsoftwares.com\/?p=1609"},"modified":"2023-05-23T04:18:43","modified_gmt":"2023-05-23T04:18:43","slug":"what-is-the-difference-between-blob-and-text","status":"publish","type":"post","link":"https:\/\/itnotes.apjsoftwares.in\/index.php\/2023\/05\/23\/what-is-the-difference-between-blob-and-text\/","title":{"rendered":"What is the difference between BLOB AND TEXT?"},"content":{"rendered":"\n<p>A BLOB is a binary large object that can hold a variable amount of data. There are four types of BLOB \u2013<\/p>\n\n\n\n<ul>\n<li>TINYBLOB<\/li>\n\n\n\n<li>BLOB<\/li>\n\n\n\n<li>MEDIUMBLOB and<\/li>\n\n\n\n<li>LONGBLOB<\/li>\n<\/ul>\n\n\n\n<p>They all differ only in the maximum length of the values they can hold.<\/p>\n\n\n\n<p>A TEXT is a case-insensitive BLOB. The four TEXT types<\/p>\n\n\n\n<ul>\n<li>TINYTEXT<\/li>\n\n\n\n<li>TEXT<\/li>\n\n\n\n<li>MEDIUMTEXT and<\/li>\n\n\n\n<li>LONGTEXT<\/li>\n<\/ul>\n\n\n\n<p>They all correspond to the four BLOB types and have the same maximum lengths and storage requirements.<\/p>\n\n\n\n<p>The only difference between BLOB and TEXT types is that sorting and comparison is performed in case-<strong>sensitive<\/strong>&nbsp;for BLOB values and case-<strong>insensitive<\/strong>&nbsp;for TEXT values.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A BLOB is a binary large object that can hold a variable amount of data&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35],"tags":[],"_links":{"self":[{"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/posts\/1609"}],"collection":[{"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/comments?post=1609"}],"version-history":[{"count":1,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/posts\/1609\/revisions"}],"predecessor-version":[{"id":1610,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/posts\/1609\/revisions\/1610"}],"wp:attachment":[{"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/media?parent=1609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/categories?post=1609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/tags?post=1609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}