Development:XMLDB column types: Difference between revisions
From MoodleDocs
Line 21: | Line 21: | ||
:'''TINYINT''' (<=2 digits) | :'''TINYINT''' (<=2 digits) | ||
</td> | </td> | ||
<td></td> | <td> | ||
<td></td> | :'''BIGINT''' (>9 digits) | ||
:'''INTEGER''' (>4 digits) | |||
:'''SMALLINT''' (<=4 digits) | |||
</td> | |||
<td> | |||
:'''NUMBER''' | |||
</td> | |||
<td></td> | <td></td> | ||
</tr> | </tr> | ||
Line 29: | Line 35: | ||
<td> | <td> | ||
:'''NUMERIC''' | :'''NUMERIC''' | ||
</td> | </td> | ||
<td></td> | <td> | ||
<td></td> | :'''NUMERIC''' | ||
</td> | |||
<td> | |||
:'''NUMBER''' | |||
</td> | |||
<td></td> | <td></td> | ||
</tr> | </tr> | ||
Line 40: | Line 50: | ||
:'''DOUBLE''' (>= 6 dec. positions) | :'''DOUBLE''' (>= 6 dec. positions) | ||
</td> | </td> | ||
<td></td> | <td> | ||
<td></td> | :'''REAL''' (< 6 dec. positions) | ||
:'''DOUBLE''' (>= 6 dec. positions) | |||
</td> | |||
<td> | |||
:'''NUMBER''' | |||
</td> | |||
<td></td> | <td></td> | ||
</tr> | </tr> | ||
Line 49: | Line 64: | ||
:'''VARCHAR''' | :'''VARCHAR''' | ||
</td> | </td> | ||
<td></td> | <td> | ||
<td></td> | :'''VARCHAR''' | ||
</td> | |||
<td> | |||
:'''VARCHAR2''' | |||
</td> | |||
<td></td> | <td></td> | ||
</tr> | </tr> | ||
Line 60: | Line 79: | ||
:'''TEXT''' | :'''TEXT''' | ||
</td> | </td> | ||
<td></td> | <td> | ||
<td></td> | :'''TEXT''' | ||
</td> | |||
<td> | |||
:'''CLOB''' | |||
</td> | |||
<td></td> | <td></td> | ||
</tr> | </tr> | ||
Line 71: | Line 94: | ||
:'''BLOB''' | :'''BLOB''' | ||
</td> | </td> | ||
<td></td> | <td> | ||
<td></td> | :'''BYTEA''' | ||
</td> | |||
<td> | |||
:'''BLOB''' | |||
</td> | |||
<td></td> | <td></td> | ||
</tr> | </tr> | ||
Line 80: | Line 107: | ||
:'''DATETIME''' | :'''DATETIME''' | ||
</td> | </td> | ||
<td></td> | <td> | ||
<td></td> | :'''TIMESTAMP''' | ||
</td> | |||
<td> | |||
:'''DATE''' | |||
</td> | |||
<td></td> | <td></td> | ||
</tr> | </tr> |
Revision as of 16:48, 23 August 2006
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 |
|
|
|
|
date with time |
|
|
|
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