Development:XMLDB column types: Difference between revisions
From MoodleDocs
mNo edit summary |
mNo edit summary |
||
Line 1: | Line 1: | ||
[[Development:XMLDB Documentation|XMLDB Documentation]] > 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. | This page will show, once finished, one compatibility matrix of column types for each of the RDBMS under which Moodle is expected to work. |
Revision as of 16:50, 28 February 2007
XMLDB Documentation > 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