XMLDB preliminary links

XML Database Schema -> XMLDB Preliminary Links

---

This page includes all the links that were found googling the Internet, searching for info, examples, paths and solutions to the whole project of increase the supported DBs working together with Moodle 1.7 and upwards.

The list below isn't ordered nor well classified, some of the links could be inaccurate, inexact or trivial, but they have been part of the preliminary work, so they will remain here. Thanks to all of them!

From ADOdb HQ

• http://adodb.sourceforge.net: ADOdb Home Page (documentation, forums, mailing lists, FAQ).
• http://phplens.com/lens/adodb/docs-adodb.htm: ADOdb Full Documentation
• http://phplens.com/lens/adodb/docs-datadict.htm: ADOdb Data Dictionary (ADOdb XML Schema).
• http://phplens.com/lens/adodb/tips_portable_sql.htm: Tips on Writing Portable SQL
• http://phplens.com/adodb/supported.databases.html: List of Supported Databases

Installation Instructions

• http://phpbuilder.com/columns/alberto20000919.php3 and http://linuxjournal.com/article/6636: Installation of SQL*Server drivers.
• http://www.oracle.com/technology/tech/php/htdocs/inst_php_apache_linux.html: Installation of Oracle Server drivers.

Useful links

• http://www.php.net/mssql: PHP's page about SQL*Server.
• http://www.php.net/manual/en/ref.oci8.php: PHP's page about Oracle.
• http://www.freetds.org/: Main page of TDS (tabular data stream) for Unix/Linux.
• http://www.toppa.com/blog/technobabble/233: Oracle and PHP talking in UTF-8

SQL*Server working in UCS-2 (no UTF-8)

• http://journeymanjournal.blogspot.com/2005/02/no-utf-8-support-in-sql-server.html: The premise.
• http://support.microsoft.com/default.aspx?scid=KB;EN-US;232580: The declaration.
• http://www.freetds.org/userguide/unicodefreetds.htm: Will this work, yes or no? Not clear documentation.
• (NP! It works! Data is converted from UCS-2 to UTF-8 by FreeDTS on the fly, using iconv).