note 106064 added to mysqli-result.fetch-field

From: Date: Fri, 07 Oct 2011 03:24:09 +0000
Subject: note 106064 added to mysqli-result.fetch-field
Groups: php.notes 
Request: Send a blank email to php-notes+get-183696@lists.php.net to get a copy of this message
here are the data types that correspond to the TYPE number returned by fetch_field. thought i would post this here since i couldn't find the info elsewhere. numerics ------------- BIT: 16 TINYINT: 1 BOOL: 1 SMALLINT: 2 MEDIUMINT: 9 INTEGER: 3 BIGINT: 8 SERIAL: 8 FLOAT: 4 DOUBLE: 5 DECIMAL: 246 NUMERIC: 246 FIXED: 246 dates ------------ DATE: 10 DATETIME: 12 TIMESTAMP: 7 TIME: 11 YEAR: 13 strings & binary ------------ CHAR: 254 VARCHAR: 253 ENUM: 254 SET: 254 BINARY: 254 VARBINARY: 253 TINYBLOB: 252 BLOB: 252 MEDIUMBLOB: 252 TINYTEXT: 252 TEXT: 252 MEDIUMTEXT: 252 LONGTEXT: 252 ---- Server IP: 69.147.83.197 Probable Submitter: 69.235.198.33 ---- Manual Page -- http://www.php.net/manual/en/mysqli-result.fetch-field.php Edit -- https://master.php.net/note/edit/106064 Del: integrated -- https://master.php.net/note/delete/106064/integrated Del: useless -- https://master.php.net/note/delete/106064/useless Del: bad code -- https://master.php.net/note/delete/106064/bad+code Del: spam -- https://master.php.net/note/delete/106064/spam Del: non-english -- https://master.php.net/note/delete/106064/non-english Del: in docs -- https://master.php.net/note/delete/106064/in+docs Del: other reasons-- https://master.php.net/note/delete/106064 Reject -- https://master.php.net/note/reject/106064 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#183696) next »