Gambas Documentation
Application Repository
Code Snippets
Compilation & Installation
Components
gb
gb.args
gb.cairo
gb.chart
gb.clipper
gb.complex
gb.compress
gb.crypt
gb.data
gb.db
gb.db.form
gb.db.mysql
gb.db.odbc
gb.db.postgresql
gb.db.sqlite2
gb.db.sqlite3
gb.dbus
gb.dbus.trayicon
gb.debug
gb.desktop
gb.desktop.gnome.keyring
gb.desktop.x11
gb.eval
gb.eval.highlight
gb.form
gb.form.dialog
gb.form.editor
gb.form.htmlview
gb.form.mdi
gb.form.print
gb.form.stock
gb.form.terminal
gb.gmp
gb.gsl
gb.gtk
gb.gtk.opengl
gb.gtk3
gb.gtk3.opengl
gb.gtk3.webview
gb.gui
gb.gui.opengl
gb.gui.qt
gb.gui.qt.ext
gb.gui.qt.opengl
gb.gui.qt.webkit
gb.gui.trayicon
gb.gui.webview
gb.hash
gb.highlight
gb.image
gb.image.effect
gb.image.imlib
gb.image.io
gb.inotify
gb.jit
gb.libxml
gb.logging
gb.map
gb.markdown
gb.media
gb.media.form
gb.memcached
gb.mime
gb.mysql
_DataBase
_DataTypes
Binary
Bit
Blob
Bool
Boolean
Char
Date
DateTime
Enum
LongBlob
LongText
MediumBlob
MediumText
Null
Serial
Set
SignedBigInt
SignedDec
SignedDecimal
SignedDouble
SignedDoublePrecision
SignedFloat
SignedInt
SignedInteger
SignedMediumInt
SignedReal
SignedSmallInt
SignedTinyInt
Text
Time
TimeStamp
TinyBlob
TinyText
UnsignedBigInt
UnsignedDec
UnsignedDecimal
UnsignedDouble
UnsignedDoublePrecision
UnsignedFloat
UnsignedInt
UnsignedInteger
UnsignedMediumInt
UnsignedReal
UnsignedSmallInt
UnsignedTinyInt
VarBinary
VarChar
Year
_Field
_Index
_MySQL
_Table
_User
_View
Connection
DB
gb.ncurses
gb.net
gb.net.curl
gb.net.pop3
gb.net.smtp
gb.openal
gb.opengl
gb.opengl.glsl
gb.opengl.glu
gb.opengl.sge
gb.openssl
gb.option
gb.pcre
gb.pdf
gb.poppler
gb.qt4
gb.qt4.ext
gb.qt4.opengl
gb.qt4.webkit
gb.qt4.webview
gb.qt5
gb.qt5.ext
gb.qt5.opengl
gb.qt5.webkit
gb.qt5.webview
gb.qt6
gb.qt6.ext
gb.qt6.opengl
gb.qt6.webview
gb.report
gb.report2
gb.scanner
gb.sdl
gb.sdl.sound
gb.sdl2
gb.sdl2.audio
gb.settings
gb.signal
gb.term
gb.test
gb.util
gb.util.web
gb.v4l
gb.vb
gb.web
gb.web.feed
gb.web.form
gb.web.gui
gb.xml
gb.xml.html
gb.xml.rpc
gb.xml.xslt
Controls pictures
Deprecated components
Developer Documentation
Development Environment Documentation
Documents
Error Messages
Gambas Playground
How To's
Language Index
Language Overviews
Last Changes
Lexicon
README
Search the wiki
To Do
Topics
Tutorials
Wiki License
Wiki Manual

_DataTypes (gb.mysql)

Provides almost all the datatypes supported by MySQL

See this page for more information.

This class is virtual.

This class is not creatable.

Constants
Bool   Returns the MySQL BOOL data type.
Boolean   Returns the MySQL BOOLEAN data type
Date   Returns the MySQL Date data type
DateTime   Returns the MySQL DATETIME data type
LongBlob   Returns the MySQL LONGBLOB data type
MediumBlob   Returns the MySQL MEDIUMBLOB data type
Null   Returns the MySQL Null datatype
Serial   Returns the MySQL SERIAL data type
SignedBigInt   Returns the MySQL BIGINT data type
SignedInt   Returns the MySQL INT data type
SignedInteger   Returns the MySQL INTEGER data type
SignedMediumInt   Returns the MySQL MEDIUMINT data type
SignedSmallInt   Returns the MySQL SMALLINT data type
SignedTinyInt   Returns the MySQL TINYINT data type
Time   Returns the MySQL TIME data type
TimeStamp   Returns the MySQL TIMESTAMP data type
TinyBlob   Returns the MySQL TINYBLOB(M) data type
UnsignedBigInt   Returns the MySQL BIGINT UNSIGNED data type
UnsignedInt   Returns the MySQL INT UNSIGNED data type
UnsignedInteger   Returns the MySQL INTEGER UNSIGNED data type
UnsignedMediumInt   Returns the MySQL MEDIUMINT UNSIGNED data type
UnsignedSmallInt   Returns the MySQL SMALLINT UNSIGNED data type
UnsignedTinyInt   Returns the MySQL TINYINT UNSIGNED data type

Methods
Binary   Returns the MySQL BINARY(M) data type. You can specify the charset and collation
Bit   Returns the MySQL BIT(M) data type
Blob   Returns the MySQL BLOB(M) data type
Char   Returns the MySQL CHAR(M) data type. You can specify the charset and collation
Enum   Returns the MySQL ENUM(M) data type. You can specify the charset and collation
LongText   Returns the MySQL LONGTEXT(M) data type. You can specify the charset and collation
MediumText   Returns the MySQL MEDIUMTEXT data type. You can specify the charset and collation
Set   Returns the MySQL SET(M) data type. You can specify the charset and collation
SignedDec   Returns the MySQL DECIMAL(M, D) data type
SignedDecimal   Returns the MySQL DECIMAL(M, D) data type
SignedDouble   Returns the MySQL DOUBLE(M, D) data type
SignedDoublePrecision   Returns the MySQL DOUBLE PRECISION(M, D) data type
SignedFloat   Returns the MySQL FLOAT(M, D) data type
SignedReal   Returns the MySQL REAL(M, D) data type
Text   Returns the MySQL TEXT(M) data type. You can specify the charset and collation
TinyText   Returns the MySQL TINYTEXT(M) data type. You can specify the charset and collation
UnsignedDec   Returns the MySQL DECIMAL(M, D) UNSIGNED data type
UnsignedDecimal   Returns the MySQL DECIMAL(M, D) UNSIGNED data type
UnsignedDouble   Returns the MySQL DOUBLE(M, D) UNSIGNED data type
UnsignedDoublePrecision   Returns the MySQL DOUBLE PRECISION(M, D) UNSIGNED data type
UnsignedFloat   Returns the MySQL FLOAT(M, D) UNSIGNED data type
UnsignedReal   Returns the MySQL REAL(M, D) UNSIGNED data type
VarBinary   Returns the MySQL VARBINARY(M) data type. You can specify the charset and collation
VarChar   Returns the MySQL VARCHAR(M) data type. You can specify the charset and collation
Year   Returns the MySQL YEAR(2|4) data type