XMLDB column types: Difference between revisions
From MoodleDocs
m (→The matrix) |
|||
Line 14: | Line 14: | ||
<tr> | <tr> | ||
<td>int</td> | <td>int</td> | ||
<td></td> | <td> | ||
:'''BIGINT''' (>9 digits) | |||
:'''INT''' (>6 digits) | |||
:'''MEDIUMINT''' (>4 digits) | |||
:'''SMALLINT''' (>2 digits) | |||
:'''TINYINT''' (<=2 digits) | |||
</td> | |||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
Line 21: | Line 27: | ||
<tr> | <tr> | ||
<td>number</td> | <td>number</td> | ||
<td></td> | <td>:'''NUMERIC'''</td> | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
Line 28: | Line 34: | ||
<tr> | <tr> | ||
<td>float</td> | <td>float</td> | ||
<td></td> | <td> | ||
* '''FLOAT''' (< 6 dec. positions) | |||
* '''DOUBLE''' (>= 6 dec. positions) | |||
</td> | |||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
Line 35: | Line 44: | ||
<tr> | <tr> | ||
<td>char</td> | <td>char</td> | ||
<td></td> | <td>'''VARCHAR'''</td> | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
Line 42: | Line 51: | ||
<tr> | <tr> | ||
<td>text</td> | <td>text</td> | ||
<td></td> | <td> | ||
* '''BIGTEXT''' | |||
* '''MEDIUMTEXT''' | |||
* '''TEXT''' | |||
</td> | |||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
Line 49: | Line 62: | ||
<tr> | <tr> | ||
<td>binary</td> | <td>binary</td> | ||
<td> | |||
* '''BIGBLOB''' | |||
* '''MEDIUMBLOB''' | |||
* '''BLOB''' | |||
</td> | |||
<td></td> | <td></td> | ||
<td></td> | |||
<td></td> | |||
</tr> | |||
<tr> | |||
<td>date with time</td> | |||
<td>'''DATETIME'''</td> | |||
<td></td> | <td></td> | ||
<td></td> | <td></td> |
Revision as of 16:40, 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 | :NUMERIC | |||
float |
|
|||
char | VARCHAR | |||
text |
|
|||
binary |
|
|||
date with time | 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