XMLDB column types: Difference between revisions
From MoodleDocs
Helen Foster (talk | contribs) m (XMLDB column types moved to Development:XMLDB column types) |
(FIELD TYPE "date with time" changed to "datetime") |
||
Line 118: | Line 118: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td> | <td>datetime</td> | ||
<td> | <td> | ||
:'''DATETIME''' | :'''DATETIME''' |
Revision as of 09:45, 2 February 2007
XML database schema > XMLDB column types
This page will show, once finished, one compatibility matrix of column types for each of the RDBMS under which Moodle is expected to work.
The matrix
XMLDB Type | MySQL | PostgreSQL | Oracle | MSSQL |
---|---|---|---|---|
int |
|
|
|
|
number |
|
|
|
|
float |
|
|
|
|
char |
|
|
|
|
text |
|
|
|
|
binary |
|
|
|
|
datetime |
|
|
|
|
Some official links
- MySQL: http://dev.mysql.com/doc/refman/5.0/en/data-types.html
- PostgreSQL: http://www.postgresql.org/docs/7.4/static/datatype.html
- SQL*Server: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_7msw.asp
- Oracle: http://www.cs.umbc.edu/help/oracle8/server.815/a68003/01_04blt.htm