Development:XMLDB column types: Difference between revisions
From MoodleDocs
mNo edit summary |
|||
Line 29: | Line 29: | ||
:'''NUMBER''' | :'''NUMBER''' | ||
</td> | </td> | ||
<td></td> | <td> | ||
:'''BIGINT''' (>9 digits) | |||
:'''INTEGER''' (>4 digits) | |||
:'''SMALLINT''' (<=4 digits) | |||
</td> | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 42: | Line 46: | ||
:'''NUMBER''' | :'''NUMBER''' | ||
</td> | </td> | ||
<td></td> | <td> | ||
:'''DECIMAL''' | |||
</td> | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 57: | Line 63: | ||
:'''NUMBER''' | :'''NUMBER''' | ||
</td> | </td> | ||
<td></td> | <td> | ||
:'''REAL''' (< 6 dec. positions) | |||
:'''FLOAT''' (>= 6 dec. positions) | |||
</td> | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 70: | Line 79: | ||
:'''VARCHAR2''' | :'''VARCHAR2''' | ||
</td> | </td> | ||
<td></td> | <td> | ||
:'''NVARCHAR''' | |||
</td> | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 85: | Line 96: | ||
:'''CLOB''' | :'''CLOB''' | ||
</td> | </td> | ||
<td></td> | <td> | ||
:'''NTEXT''' | |||
</td> | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 100: | Line 113: | ||
:'''BLOB''' | :'''BLOB''' | ||
</td> | </td> | ||
<td></td> | <td> | ||
:'''IMAGE''' | |||
</td> | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 113: | Line 128: | ||
:'''DATE''' | :'''DATE''' | ||
</td> | </td> | ||
<td></td> | <td> | ||
:'''DATETIME''' | |||
</td> | |||
</tr> | </tr> | ||
</table> | </table> |
Revision as of 16:51, 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