Development:XMLDB column types: Difference between revisions
From MoodleDocs
mNo edit summary |
|||
Line 72: | Line 72: | ||
<td> | <td> | ||
:'''VARCHAR''' | :'''VARCHAR''' | ||
<small><5.0.3 0-255 chars, >=5.0.3 0-65535 chars</small> | |||
</td> | </td> | ||
<td> | <td> | ||
:'''VARCHAR''' | :'''VARCHAR''' | ||
<small>about 1GB ot text</small> | |||
</td> | </td> | ||
<td> | <td> | ||
:'''VARCHAR2''' | :'''VARCHAR2''' | ||
<small>4000 bytes</small> | |||
</td> | </td> | ||
<td> | <td> | ||
:'''NVARCHAR''' | :'''NVARCHAR''' | ||
<small>4000 chars</small> | |||
</td> | </td> | ||
</tr> | </tr> |
Revision as of 21:01, 14 March 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 |
<5.0.3 0-255 chars, >=5.0.3 0-65535 chars |
about 1GB ot text |
4000 bytes |
4000 chars |
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