← Back to team overview

maria-discuss team mailing list archive

New Question: Which datatypes are supported by MariaDB



A new question has been asked in "Getting Started" by giordano:
I would like to know which datatypes are supported by MariaDB. I'm asking since I'm little confused. For example, the knowledge base contains a chapter temporal datatypes:

where the the datatype timestamp is defined:
"it defines a set of correctly formed values that represent any valid Gregorian calendar date between '0001-01-01' and '9999-12-31'"

If I look at the MySQL-site

The definition for timestamp is:
"The TIMESTAMP data type is used for values that contain both date and time parts. TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC." 

These are different definitions.I know that the datatype defintions in the knowledge base contains the syntax of SQL-99. What makes me insecure is which definition has priority. 

Also I do not know if all datatypes in Oracle-MySQL are supported by MariaDB. For example, tinyint, bigint. (Sincerly, I know that MariaDB understand these datatypes, but I wonder if they have the same definition as given by the Oracle-MySQL-site.)
Thanks for help

To view or answer this question please visit: http://kb.askmonty.org/en/which-datatypes-are-supported-by-mariadb/