Development:XMLDB column types
From MoodleDocs
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 |
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
