<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://docs.moodle.org/dev/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Roal</id>
	<title>MoodleDocs - User contributions [en]</title>
	<link rel="self" type="application/atom+xml" href="https://docs.moodle.org/dev/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Roal"/>
	<link rel="alternate" type="text/html" href="https://docs.moodle.org/dev/Special:Contributions/Roal"/>
	<updated>2026-04-16T18:22:13Z</updated>
	<subtitle>User contributions</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>https://docs.moodle.org/dev/index.php?title=Clean_theme&amp;diff=43846</id>
		<title>Clean theme</title>
		<link rel="alternate" type="text/html" href="https://docs.moodle.org/dev/index.php?title=Clean_theme&amp;diff=43846"/>
		<updated>2014-02-13T16:06:23Z</updated>

		<summary type="html">&lt;p&gt;Roal: Added link to Discussion in Themes Forum&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;{{Template:Themes}}{{Moodle 2.5}}This document describes how to copy and customise the Clean (bootstrapbase) theme so that you can build on this to create a theme of your own. It assumes you have some understanding of how themes work within Moodle 2.5, as well as a basic understanding of HTML and CSS. Also, because of the rapid development within Moodle, resulting in a number of versions available namely 2.3.x and 2.4.x, and 2.5.x it is important to understand that this tutorial is only valid for the Moodle 2.5+ Clean theme.&lt;br /&gt;
&lt;br /&gt;
==Getting started==&lt;br /&gt;
&lt;br /&gt;
From your Moodle &#039;&#039;&#039;theme&#039;&#039;&#039; directory &#039;&#039;&#039;right click&#039;&#039;&#039; on the &#039;&#039;&#039;clean&#039;&#039;&#039; theme and then &#039;&#039;&#039;&#039;&#039;copy&#039;&#039;&#039; and  &#039;&#039;&#039;paste&#039;&#039;&#039;&#039;&#039; back into your Moodle &#039;&#039;&#039;theme&#039;&#039;&#039; directory. You should now have a folder called &#039;&#039;&#039;Copy of clean&#039;&#039;&#039;. If you &#039;&#039;&#039;right click&#039;&#039;&#039; this folder you are given the option to &#039;&#039;&#039;Rename&#039;&#039;&#039; it. So rename this folder to your choosen theme name, using only lower case letters, and if needed, underscores. For the purpose of this tutorial we will call the theme &#039;cleantheme&#039;.&lt;br /&gt;
&lt;br /&gt;
On opening &#039;cleantheme&#039; you will find several files and sub-directories which have files within them.&lt;br /&gt;
&lt;br /&gt;
These are:&lt;br /&gt;
; config.php :  Where all the theme configurations are made. &#039;&#039;(contains some elements that require renaming)&#039;&#039;&lt;br /&gt;
; lib.php :  Where all the functions for the themes settings are found. &#039;&#039;(contains some elements that require renaming)&#039;&#039;&lt;br /&gt;
; settings.php :  Where all the setting for this theme are created. &#039;&#039;(contains some elements that require renaming)&#039;&#039;&lt;br /&gt;
; version.php :  Where the version number and plugin componant information is kept. &#039;&#039;(contains some elements that require renaming)&#039;&#039;&lt;br /&gt;
; /lang/ : This directory contains all language sub-directories for other languages if and when you want to add them.&lt;br /&gt;
; /lang/en/ : This sub-directory contains your language files, in this case &#039;&#039;English&#039;&#039;.&lt;br /&gt;
; /lang/en/theme_clean.php : This file contains all the language strings for your theme. &#039;&#039;(contains some elements that require renaming as well as the filename itself)&#039;&#039;  &lt;br /&gt;
; /layout/ : This directory contains all the layout files for this theme.&lt;br /&gt;
; /layout/columns1.php : Layout file for a one column layout (content only).&lt;br /&gt;
; /layout/columns2.php : Layout file for a two column layout (side-pre and content).&lt;br /&gt;
; /layout/columns3.php : Layout file for a three column layout (side-pre, content and side-post) and the front page.&lt;br /&gt;
; /layout/embedded.php : Embedded layout file for embeded pages, like iframe/object embeded in moodleform - it needs as much space as possible.&lt;br /&gt;
; /layout/maintenance.php : Maintenance layout file which does not have any blocks, links, or API calls that would lead to database or cache interaction.&lt;br /&gt;
; /layout/secure.php : Secure layout file for safebrowser and securewindow.&lt;br /&gt;
; /style/ : This directory contains all the CSS files for this theme.&lt;br /&gt;
; /style/custom.css : This is where all the settings CSS is generated.&lt;br /&gt;
; /pix/ : This directory contains a screen shot of this theme as well as a favicon and any images used in the theme.&lt;br /&gt;
&lt;br /&gt;
==Renaming Elements==&lt;br /&gt;
&lt;br /&gt;
The problem when &#039;&#039;&#039;cloning&#039;&#039;&#039; a theme is that you need to rename all those instances where the old theme name occurs, in this case &#039;&#039;&#039;clean&#039;&#039;&#039;. So using the above list as a guide, search through and change all the instances of the theme name &#039;clean&#039; to &#039;cleantheme&#039;. This includes the filename of the lang/en/theme_clean.php. You need to change this to &#039;theme_cleantheme.php&#039;.&lt;br /&gt;
&lt;br /&gt;
==Installing your theme==&lt;br /&gt;
&lt;br /&gt;
Once all the changes to the name have been made, you can safely install the theme. If you are already logged in just refreshing the browser should trigger your Moodle site to begin the install &#039;Plugins Check&#039;. If not then navigate to Administration &amp;gt; Notifications.&lt;br /&gt;
&lt;br /&gt;
Once your theme is successfully installed you can select it and begin to modify it using the custom settings page found by navigating to Administration &amp;gt; Site Administration &amp;gt; Appearance &amp;gt; Themes &amp;gt;&amp;gt; and then click on (Cleantheme) or whatever you renamed your theme to, from the list of theme names that appear at this point in the side block.&lt;br /&gt;
&lt;br /&gt;
==Include a renderer in a bootstrap based theme==&lt;br /&gt;
&lt;br /&gt;
If you need to override any renderers in your theme, then make sure you override the renderers by extending the parent theme renderers, which in this case is bootstrapbase. For example the class that you need to start your renderer with is as follows...&lt;br /&gt;
&lt;br /&gt;
&amp;lt;code php&amp;gt;&lt;br /&gt;
class theme_yourtheme_core_renderer extends theme_bootstrapbase_core_renderer {&lt;br /&gt;
 &lt;br /&gt;
}&lt;br /&gt;
&amp;lt;/code&amp;gt;&lt;br /&gt;
&lt;br /&gt;
...where &#039;&#039;&#039;&#039;yourtheme&#039;&#039;&#039;&#039; requires you to change it to your theme name otherwise it will not work.&lt;br /&gt;
&lt;br /&gt;
(Please note: The normal recipe &amp;lt;tt&amp;gt;class theme_&#039;&#039;&#039;yourtheme&#039;&#039;&#039;_core_renderer extends core_renderer&amp;lt;/tt&amp;gt; is wrong for themes whose parent theme uses renderers, because this method will ultimately conflict with the parent theme&#039;s renderers.)&lt;br /&gt;
&lt;br /&gt;
==See also==&lt;br /&gt;
&lt;br /&gt;
* [http://www.somerandomthoughts.com/blog/2013/05/08/moodle-2-5-and-the-bootstrap-based-theme-clean/ Moodle 2.5 and the Bootstrap based theme – Clean] blog post by Gavin Henrick&lt;br /&gt;
* [http://basbrands.nl/blog/2013/05/21/building-with-bootstrap/ Building With Bootstrap] blog post by Bas Brands&lt;br /&gt;
* [https://moodle.org/mod/forum/discuss.php?d=239967 Problems cloning &amp;quot;clean&amp;quot; theme] Discussion in &#039;&#039;Themes&#039;&#039; Forum&lt;/div&gt;</summary>
		<author><name>Roal</name></author>
	</entry>
	<entry>
		<id>https://docs.moodle.org/dev/index.php?title=Roadmap&amp;diff=26160</id>
		<title>Roadmap</title>
		<link rel="alternate" type="text/html" href="https://docs.moodle.org/dev/index.php?title=Roadmap&amp;diff=26160"/>
		<updated>2007-02-03T19:34:58Z</updated>

		<summary type="html">&lt;p&gt;Roal: note about removement of pre-1.7 DB install/upgrade system&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;This roadmap collects the best information about upcoming features in Moodle.   It is not 100% certain - features may change according to available funding and developers.&lt;br /&gt;
&lt;br /&gt;
== Version 1.8 - Expected February 2007 ==&lt;br /&gt;
&lt;br /&gt;
* [[Accessibility]] - Moodle.com &lt;br /&gt;
:: Compliance with all major accessibility standards&lt;br /&gt;
* [[Moodle forms library]] - Moodle.com &lt;br /&gt;
:: All forms can now use a single API for defining forms consistently and collecting data safely.&lt;br /&gt;
* [[Multi Authentication]] - Iñaki Arenaza / Jonathan Harker (Catalyst) / Martin Langhoff (Catalyst)&lt;br /&gt;
* [[Development:Customisable user profiles|Customisable User Profiles]] - Pukunui Technology&lt;br /&gt;
::Allow fields to be added to the user profile.&lt;br /&gt;
* [[Moodle Network]] - Catalyst and Moodle.com&lt;br /&gt;
:: Setup peer Moodle installations allowing users to roam across, using comprehensive SSO and transparent remote enrolments. Administrators at the originating Moodle install can see logs of remote activity. You can also run your Moodle in &amp;quot;Hub&amp;quot; mode where any Moodle install can connect and users roam across.&lt;br /&gt;
::[[Web Services API]] for Moodle communications. The Moodle Network code includes an XML-RPC call dispatcher that can expose the whole Moodle API to trusted hosts.&lt;br /&gt;
* Groups refactor - Juliette White / Nick Freear  (OU)&lt;br /&gt;
::Groups code will be reorganised to make it more flexible for the future (see 1.9)&lt;br /&gt;
* [[Authorize.net Payment Gateway]] enrolment plugin &lt;br /&gt;
:: Payment managers can obtain an authorization code over phone from customer&#039;s bank if the credit card of the user cannot be captured on the internet directly.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Version 1.9 - Expected May 2007 ==&lt;br /&gt;
&lt;br /&gt;
* [[Development:Grades|Gradebook development]]&lt;br /&gt;
::The gradebook system will be revamped for performance, switching from our older &amp;quot;pull&amp;quot; model to a &amp;quot;push&amp;quot; model where all modules will now publish grades as necessary into a central table.&lt;br /&gt;
* [[Metadata]] - Moodle.com&lt;br /&gt;
::Build on the keywords in 1.6 to provide metadata for all activities and courses, linkable to standard lists of metadata such as State-based learning outcomes and curricula&lt;br /&gt;
* [[Repository API]] - Open University, Moodle.com and Humboldt&lt;br /&gt;
::Abstract all file operations to an API that allows plugins for different external repositories&lt;br /&gt;
* [[Learning Design export]] - Moodle.com and Open University of The Netherlands&lt;br /&gt;
::We plan to have a very simple export for any Moodle course into IMS LD format, as a proof of concept and to help the community start learning about IMS LD.&lt;br /&gt;
* [[Development:Groups_documentation_for_module_developers|New groups]] - Open University&lt;br /&gt;
::Site-wide groups, reusable groups, and assigning activities to groups are the major improvements being developed  &lt;br /&gt;
* Blog commenting &lt;br /&gt;
:: You&#039;ll be able to make comments on blogs!  In time, all comments in Moodle will be merged into the same commenting system.&lt;br /&gt;
* SCORM 2004?&lt;br /&gt;
* Integrate nwiki?&lt;br /&gt;
* Integrate Feedback module?&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Version 2.0 - Expected August 2007 ==&lt;br /&gt;
&lt;br /&gt;
* [[IMS Learning Design]] - Moodle.com&lt;br /&gt;
::Support for importing/exporting LD, converting Moodle activities and sequences of activities into a standard format for sharing, and importing standard sequences into Moodle courses&lt;br /&gt;
* [[Conditional activities]] - Moodle.com&lt;br /&gt;
::Allowing dependencies and forced paths through the content&lt;br /&gt;
* [[Community hub]] interfaces - Moodle.com and others&lt;br /&gt;
::Makes it easy for users to find and navigate other systems and external Moodle repositories, leveraging the Moodle Network in various ways.&lt;br /&gt;
* [[Student Information API]]&lt;br /&gt;
::API for integrating external systems for managing student information&lt;br /&gt;
* Old DB install/upgrade system removed&lt;br /&gt;
:: The deprecated system for installing or upgrading database entries used in Moodle &amp;lt; 1.7 will be completely removed, while supporting only the new XML based database scheme introduced in 1.7&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;Note: Moodle 2.0 will require PHP 5.1 as a minimum, because of certain improvements not available in PHP 4.&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
== Version 2.1 ==&lt;br /&gt;
&lt;br /&gt;
* [[Portfolio API]]&lt;br /&gt;
::Interface Moodle activities and repositories to help produce portfolios for internal assessment AND external publication&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
[[Category:Developer]]&lt;br /&gt;
[[Category:Future]]&lt;br /&gt;
&lt;br /&gt;
[[es:Planificación]]&lt;br /&gt;
[[fr:Planification]]&lt;/div&gt;</summary>
		<author><name>Roal</name></author>
	</entry>
	<entry>
		<id>https://docs.moodle.org/dev/index.php?title=XMLDB_column_types&amp;diff=3542</id>
		<title>XMLDB column types</title>
		<link rel="alternate" type="text/html" href="https://docs.moodle.org/dev/index.php?title=XMLDB_column_types&amp;diff=3542"/>
		<updated>2007-02-02T09:45:47Z</updated>

		<summary type="html">&lt;p&gt;Roal: FIELD TYPE &amp;quot;date with time&amp;quot; changed to &amp;quot;datetime&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[XML database schema]] &amp;gt; XMLDB column types&lt;br /&gt;
----&lt;br /&gt;
This page will show, once finished, one compatibility matrix of column types for each of the RDBMS under which Moodle is expected to work.&lt;br /&gt;
&lt;br /&gt;
== The matrix ==&lt;br /&gt;
&lt;br /&gt;
&amp;lt;table align=&amp;quot;center&amp;quot; border=&amp;quot;1&amp;quot; cellpadding=&amp;quot;5&amp;quot;&amp;gt;&lt;br /&gt;
  &amp;lt;tr&amp;gt;&lt;br /&gt;
    &amp;lt;th&amp;gt;&#039;&#039;&#039;XMLDB Type&#039;&#039;&#039;&amp;lt;/th&amp;gt;&lt;br /&gt;
    &amp;lt;th&amp;gt;&#039;&#039;&#039;MySQL&#039;&#039;&#039;&amp;lt;/th&amp;gt;&lt;br /&gt;
    &amp;lt;th&amp;gt;&#039;&#039;&#039;PostgreSQL&#039;&#039;&#039;&amp;lt;/th&amp;gt;&lt;br /&gt;
    &amp;lt;th&amp;gt;&#039;&#039;&#039;Oracle&#039;&#039;&#039;&amp;lt;/th&amp;gt;&lt;br /&gt;
    &amp;lt;th&amp;gt;&#039;&#039;&#039;MSSQL&amp;lt;/th&amp;gt;&amp;lt;/tr&amp;gt;&lt;br /&gt;
  &amp;lt;tr&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;int&amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;BIGINT&#039;&#039;&#039; (&amp;gt;9 digits)&lt;br /&gt;
:&#039;&#039;&#039;INT&#039;&#039;&#039; (&amp;gt;6 digits)&lt;br /&gt;
:&#039;&#039;&#039;MEDIUMINT&#039;&#039;&#039; (&amp;gt;4 digits)&lt;br /&gt;
:&#039;&#039;&#039;SMALLINT&#039;&#039;&#039; (&amp;gt;2 digits)&lt;br /&gt;
:&#039;&#039;&#039;TINYINT&#039;&#039;&#039; (&amp;lt;=2 digits)&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;BIGINT&#039;&#039;&#039; (&amp;gt;9 digits)&lt;br /&gt;
:&#039;&#039;&#039;INTEGER&#039;&#039;&#039; (&amp;gt;4 digits)&lt;br /&gt;
:&#039;&#039;&#039;SMALLINT&#039;&#039;&#039; (&amp;lt;=4 digits)&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;NUMBER&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;BIGINT&#039;&#039;&#039; (&amp;gt;9 digits)&lt;br /&gt;
:&#039;&#039;&#039;INTEGER&#039;&#039;&#039; (&amp;gt;4 digits)&lt;br /&gt;
:&#039;&#039;&#039;SMALLINT&#039;&#039;&#039; (&amp;lt;=4 digits)&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
  &amp;lt;/tr&amp;gt;&lt;br /&gt;
  &amp;lt;tr&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;number&amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;NUMERIC&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;NUMERIC&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;NUMBER&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;DECIMAL&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
  &amp;lt;/tr&amp;gt;&lt;br /&gt;
  &amp;lt;tr&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;float&amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;FLOAT&#039;&#039;&#039; (&amp;lt; 6 dec. positions)&lt;br /&gt;
:&#039;&#039;&#039;DOUBLE&#039;&#039;&#039; (&amp;gt;= 6 dec. positions)&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;REAL&#039;&#039;&#039; (&amp;lt; 6 dec. positions)&lt;br /&gt;
:&#039;&#039;&#039;DOUBLE PRECISION&#039;&#039;&#039; (&amp;gt;= 6 dec. positions)&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;NUMBER&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;REAL&#039;&#039;&#039; (&amp;lt; 6 dec. positions)&lt;br /&gt;
:&#039;&#039;&#039;FLOAT&#039;&#039;&#039; (&amp;gt;= 6 dec. positions)&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
  &amp;lt;/tr&amp;gt;&lt;br /&gt;
  &amp;lt;tr&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;char&amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;VARCHAR&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;VARCHAR&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;VARCHAR2&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;NVARCHAR&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
  &amp;lt;/tr&amp;gt;&lt;br /&gt;
  &amp;lt;tr&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;text&amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;LONGTEXT&#039;&#039;&#039;&lt;br /&gt;
:&#039;&#039;&#039;MEDIUMTEXT&#039;&#039;&#039;&lt;br /&gt;
:&#039;&#039;&#039;TEXT&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;TEXT&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;CLOB&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;NTEXT&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
  &amp;lt;/tr&amp;gt;&lt;br /&gt;
  &amp;lt;tr&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;binary&amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;LONGBLOB&#039;&#039;&#039;&lt;br /&gt;
:&#039;&#039;&#039;MEDIUMBLOB&#039;&#039;&#039;&lt;br /&gt;
:&#039;&#039;&#039;BLOB&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;BYTEA&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;BLOB&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;IMAGE&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
  &amp;lt;/tr&amp;gt;&lt;br /&gt;
  &amp;lt;tr&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;datetime&amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;DATETIME&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;TIMESTAMP&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;DATE&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
    &amp;lt;td&amp;gt;&lt;br /&gt;
:&#039;&#039;&#039;DATETIME&#039;&#039;&#039;&lt;br /&gt;
    &amp;lt;/td&amp;gt;&lt;br /&gt;
  &amp;lt;/tr&amp;gt;&lt;br /&gt;
&amp;lt;/table&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Some official links ==&lt;br /&gt;
&lt;br /&gt;
* MySQL: http://dev.mysql.com/doc/refman/5.0/en/data-types.html&lt;br /&gt;
* PostgreSQL: http://www.postgresql.org/docs/7.4/static/datatype.html&lt;br /&gt;
* SQL*Server: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_7msw.asp&lt;br /&gt;
* Oracle: http://www.cs.umbc.edu/help/oracle8/server.815/a68003/01_04blt.htm&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
[[Category:XMLDB]]&lt;/div&gt;</summary>
		<author><name>Roal</name></author>
	</entry>
</feed>