{"id":846,"date":"2026-10-13T02:40:04","date_gmt":"2026-10-13T02:40:04","guid":{"rendered":"https:\/\/sites.rutgers.edu\/joann-ordille\/?page_id=846"},"modified":"2026-10-13T02:40:04","modified_gmt":"2026-10-13T02:40:04","slug":"data-types","status":"publish","type":"page","link":"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/","title":{"rendered":"Data Types"},"content":{"rendered":"

Table 2.5.2: Common MySQL data types: INTEGER<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n
Data type<\/strong><\/th>\nStorage<\/strong><\/th>\nNotes<\/strong><\/th>\n<\/tr>\n<\/thead>\n
TINYINT<\/strong><\/th>\n1 byte<\/th>\nSigned range: -128 to 127
\nUnsigned range: 0 to 255<\/th>\n<\/tr>\n
SMALLINT<\/strong><\/th>\n2 bytes<\/td>\nSigned range: -32,768 to 32,767
\nUnsigned range: 0 to 65,535<\/td>\n<\/tr>\n
MEDIUMINT<\/strong><\/th>\n3 bytes<\/td>\nSigned range: -8,388,608 to 8,388,607
\nUnsigned range: 0 to 16,777,215<\/td>\n<\/tr>\n
INTEGER or INT<\/strong><\/th>\n4 bytes<\/td>\nSigned range: -2,147,483,648 to 2,147,483,647
\nUnsigned range: 0 to 4,294,967,295<\/td>\n<\/tr>\n
BIGINT<\/strong><\/th>\n8 bytes<\/td>\nSigned range: -263<\/sup> to 263<\/sup> -1
\nUnsigned range: 0 to 264<\/sup> -1<\/p>\n

263 <\/sup>is 9,223,372,036,854,775,808.<\/p>\n

264 <\/sup>is 18,446,744,073,709,551,616.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Table 2.5.2: Common MySQL data types: DECIMAL<\/strong><\/p>\n\n\n\n\n\n\n\n
Data type<\/strong><\/th>\nStorage<\/strong><\/th>\nNotes<\/strong><\/th>\n<\/tr>\n<\/thead>\n
DECIMAL(M,D)<\/strong><\/th>\nVaries depending on M<\/em> and D<\/em><\/th>\nExact decimal number where M<\/em> = number of significant digits, D<\/em> = number of digits after decimal point<\/th>\n<\/tr>\n
FLOAT<\/strong><\/th>\n4 bytes<\/td>\nApproximate decimal numbers with range: -3.4E+38 to 3.4E+38<\/td>\n<\/tr>\n
DOUBLE<\/strong><\/th>\n8 bytes<\/td>\nApproximate decimal numbers with range: -1.8E+308 to 1.8E+308<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Table 2.5.2: Common MySQL data types: DATE and TIME<\/strong><\/p>\n\n\n\n\n\n\n\n
Data type<\/strong><\/th>\nStorage<\/strong><\/th>\nNotes<\/strong><\/th>\n<\/tr>\n<\/thead>\n
DATE<\/strong><\/th>\n3 bytes<\/th>\nFormat: YYYY-MM-DD. Range: ‘1000-01-01’ to ‘9999-12-31’<\/th>\n<\/tr>\n
TIME<\/strong><\/th>\n3 bytes<\/td>\nFormat: hh:mm:ss<\/td>\n<\/tr>\n
DATETIME<\/strong><\/th>\n5 bytes<\/td>\nFormat: YYYY-MM-DD hh:mm:ss. Range: ‘1000-01-01 00:00:00’ to ‘9999-12-31 23:59:59’.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Table 2.5.2: Common MySQL data types: CHARACTER<\/strong><\/p>\n\n\n\n\n\n\n\n
Data type<\/strong><\/th>\nStorage<\/strong><\/th>\nNotes<\/strong><\/th>\n<\/tr>\n<\/thead>\n
CHAR(N)<\/strong><\/th>\nN<\/em> bytes<\/th>\nFixed-length string of length N<\/em>; 0 \u2264 N<\/em> \u2264 255<\/th>\n<\/tr>\n
VARCHAR(N)<\/strong><\/th>\nNumber of characters
\n+ 1 byte if N \u2264 255
\n+ 2 bytes if N > 255<\/td>\n		Variable-length string with maximum N<\/em> characters; 0 \u2264 N<\/em> \u2264 65,535<\/td>\n<\/tr>\n
TEXT<\/strong><\/th>\nNumber of characters
\n+ 2 bytes<\/td>\n		Variable-length string with maximum 65,535 characters<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Table 2.5.2: Common MySQL data types: INTEGER Data type Storage Notes TINYINT 1 byte Signed range: -128 to 127 Unsigned range: 0 to 255 SMALLINT 2 bytes Signed range: -32,768 … Read More<\/a><\/p>\n","protected":false},"author":1815,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-846","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nData Types - Joann J. Ordille<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Types - Joann J. Ordille\" \/>\n<meta property=\"og:description\" content=\"Table 2.5.2: Common MySQL data types: INTEGER Data type Storage Notes TINYINT 1 byte Signed range: -128 to 127 Unsigned range: 0 to 255 SMALLINT 2 bytes Signed range: -32,768 … Read More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/\" \/>\n<meta property=\"og:site_name\" content=\"Joann J. Ordille\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/\",\"url\":\"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/\",\"name\":\"Data Types - Joann J. Ordille\",\"isPartOf\":{\"@id\":\"https:\/\/sites.rutgers.edu\/joann-ordille\/#website\"},\"datePublished\":\"2026-10-13T02:40:04+00:00\",\"dateModified\":\"2026-10-13T02:40:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sites.rutgers.edu\/joann-ordille\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Types\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sites.rutgers.edu\/joann-ordille\/#website\",\"url\":\"https:\/\/sites.rutgers.edu\/joann-ordille\/\",\"name\":\"Joann J. Ordille\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sites.rutgers.edu\/joann-ordille\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Types - Joann J. Ordille","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:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/","og_locale":"en_US","og_type":"article","og_title":"Data Types - Joann J. Ordille","og_description":"Table 2.5.2: Common MySQL data types: INTEGER Data type Storage Notes TINYINT 1 byte Signed range: -128 to 127 Unsigned range: 0 to 255 SMALLINT 2 bytes Signed range: -32,768 … Read More","og_url":"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/","og_site_name":"Joann J. Ordille","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/","url":"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/","name":"Data Types - Joann J. Ordille","isPartOf":{"@id":"https:\/\/sites.rutgers.edu\/joann-ordille\/#website"},"datePublished":"2026-10-13T02:40:04+00:00","dateModified":"2026-10-13T02:40:04+00:00","breadcrumb":{"@id":"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sites.rutgers.edu\/joann-ordille\/data-types\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sites.rutgers.edu\/joann-ordille\/"},{"@type":"ListItem","position":2,"name":"Data Types"}]},{"@type":"WebSite","@id":"https:\/\/sites.rutgers.edu\/joann-ordille\/#website","url":"https:\/\/sites.rutgers.edu\/joann-ordille\/","name":"Joann J. Ordille","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sites.rutgers.edu\/joann-ordille\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/sites.rutgers.edu\/joann-ordille\/wp-json\/wp\/v2\/pages\/846","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.rutgers.edu\/joann-ordille\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sites.rutgers.edu\/joann-ordille\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sites.rutgers.edu\/joann-ordille\/wp-json\/wp\/v2\/users\/1815"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.rutgers.edu\/joann-ordille\/wp-json\/wp\/v2\/comments?post=846"}],"version-history":[{"count":1,"href":"https:\/\/sites.rutgers.edu\/joann-ordille\/wp-json\/wp\/v2\/pages\/846\/revisions"}],"predecessor-version":[{"id":847,"href":"https:\/\/sites.rutgers.edu\/joann-ordille\/wp-json\/wp\/v2\/pages\/846\/revisions\/847"}],"wp:attachment":[{"href":"https:\/\/sites.rutgers.edu\/joann-ordille\/wp-json\/wp\/v2\/media?parent=846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}