Development:XMLDB column types: Difference between revisions

Revision as of 16:41, 23 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.

XMLDB Type	MySQL	PostgreSQL	Oracle	MSSQL
int	BIGINT (>9 digits) INT (>6 digits) MEDIUMINT (>4 digits) SMALLINT (>2 digits) TINYINT (<=2 digits)
number	NUMERIC
float	FLOAT (< 6 dec. positions) DOUBLE (>= 6 dec. positions)
char	VARCHAR
text	BIGTEXT MEDIUMTEXT TEXT
binary	BIGBLOB MEDIUMBLOB BLOB
date with time	DATETIME

@@ Line 20: / Line 20: @@
 :'''SMALLINT''' (>2 digits)
 :'''TINYINT''' (<=2 digits)
-</td>
+    </td>
      <td></td>
      <td></td>
@@ Line 27: / Line 27: @@
    <tr>
      <td>number</td>
-     <td>:'''NUMERIC'''</td>
+     <td>
+:'''NUMERIC'''
+</td>
      <td></td>
      <td></td>
@@ Line 35: / Line 37: @@
      <td>float</td>
      <td>
-* '''FLOAT''' (< 6 dec. positions)
+:'''FLOAT''' (< 6 dec. positions)
-* '''DOUBLE''' (>= 6 dec. positions)
+:'''DOUBLE''' (>= 6 dec. positions)
-</td>
+    </td>
      <td></td>
      <td></td>
@@ Line 44: / Line 46: @@
    <tr>
      <td>char</td>
-     <td>'''VARCHAR'''</td>
+     <td>
+:'''VARCHAR'''
+    </td>
      <td></td>
      <td></td>
@@ Line 52: / Line 56: @@
      <td>text</td>
      <td>
-* '''BIGTEXT'''
+:'''BIGTEXT'''
-* '''MEDIUMTEXT'''
+:'''MEDIUMTEXT'''
-* '''TEXT'''
+:'''TEXT'''
-</td>
+    </td>
      <td></td>
      <td></td>
@@ Line 63: / Line 67: @@
      <td>binary</td>
      <td>
-* '''BIGBLOB'''
+:'''BIGBLOB'''
-* '''MEDIUMBLOB'''
+:'''MEDIUMBLOB'''
-* '''BLOB'''
+:'''BLOB'''
-</td>
+    </td>
      <td></td>
      <td></td>
@@ Line 73: / Line 77: @@
    <tr>
      <td>date with time</td>
-     <td>'''DATETIME'''</td>
+     <td>
+:'''DATETIME'''
+    </td>
      <td></td>
      <td></td>