Development: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
