XMLDB column types: Difference between revisions
From MoodleDocs
Helen Foster (talk | contribs) m (categories) |
m (→The matrix) |
||
Line 4: | Line 4: | ||
== The matrix == | == The matrix == | ||
<table align="center" border="1" cellpadding="5"> | |||
<tr> | |||
<th>'''XMLDB Type'''</th> | |||
<th>'''MySQL'''</th> | |||
<th>'''PostgreSQL'''</th> | |||
<th>'''Oracle'''</th> | |||
<th>'''MSSQL</th></tr> | |||
<tr> | |||
<td>int</td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
</tr> | |||
<tr> | |||
<td>number</td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
</tr> | |||
<tr> | |||
<td>float</td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
</tr> | |||
<tr> | |||
<td>char</td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
</tr> | |||
<tr> | |||
<td>text</td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
</tr> | |||
<tr> | |||
<td>binary</td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
</tr> | |||
</table> | |||
== Some official links == | == Some official links == |
Revision as of 22:34, 9 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 |
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