note 106064 added to mysqli-result.fetch-field
| From: | iansoko at hotmail dot com | 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