XMLDB column types: Difference between revisions
From MoodleDocs
Line 20: | Line 20: | ||
:'''SMALLINT''' (>2 digits) | :'''SMALLINT''' (>2 digits) | ||
:'''TINYINT''' (<=2 digits) | :'''TINYINT''' (<=2 digits) | ||
</td> | </td> | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
Line 27: | Line 27: | ||
<tr> | <tr> | ||
<td>number</td> | <td>number</td> | ||
<td>:'''NUMERIC'''</td> | <td> | ||
:'''NUMERIC''' | |||
</td> | |||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
Line 35: | Line 37: | ||
<td>float</td> | <td>float</td> | ||
<td> | <td> | ||
:'''FLOAT''' (< 6 dec. positions) | |||
:'''DOUBLE''' (>= 6 dec. positions) | |||
</td> | </td> | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
Line 44: | Line 46: | ||
<tr> | <tr> | ||
<td>char</td> | <td>char</td> | ||
<td>'''VARCHAR'''</td> | <td> | ||
:'''VARCHAR''' | |||
</td> | |||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
Line 52: | Line 56: | ||
<td>text</td> | <td>text</td> | ||
<td> | <td> | ||
:'''BIGTEXT''' | |||
:'''MEDIUMTEXT''' | |||
:'''TEXT''' | |||
</td> | </td> | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
Line 63: | Line 67: | ||
<td>binary</td> | <td>binary</td> | ||
<td> | <td> | ||
:'''BIGBLOB''' | |||
:'''MEDIUMBLOB''' | |||
:'''BLOB''' | |||
</td> | </td> | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
Line 73: | Line 77: | ||
<tr> | <tr> | ||
<td>date with time</td> | <td>date with time</td> | ||
<td>'''DATETIME'''</td> | <td> | ||
:'''DATETIME''' | |||
</td> | |||
<td></td> | <td></td> | ||
<td></td> | <td></td> |
Revision as of 16:41, 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