Extension:MSSQLBackCompat

MediaWiki extensions manual - list

MSSQLBackCompat Release status: beta
Implementation	Database
Description	Back compat hack for those that need non core MSSQL support (SMW, ED or something)
MediaWiki	1.17+
License	GPLv2
Download	Download snapshot (Git master) Git [?]: repo summary • tree • code changes SVN [?]: checkout-url • tree • code changes
Check usage (experimental)

This extension allow MediaWiki to query a Microsoft SQL database from Linux. It is not recommended for general everyday because to install it, you'll have to modify a file in the main files of MediaWiki. It is broken to use a the main MediaWiki databse but quite useful for extensions that query a database for other informations such as External Data.

Introduction

On Windows platforms, in PHP 5.3 and later, the mssql extension is being phased out in favor of SQLDRV, a Windows only extension. MediaWiki has followed and removed the old implementation and replaced it with SQLDRV.

On Unix/Linux platforms, the mssql extension is still supported and use the FreeTDS library. This extension make use of it.

Installation

1. Download the files from SVN and place them in $IP/extensions/MSSQLBackCompat/
2. Add
   require_once( "$IP/extensions/MSSQLBackCompat/MSSQLBackCompat.php" );
   into your wiki's LocalSettings.php

Configuration

Suggested modification to your /etc/freetds.conf configuration file. UTF-8 allow you to use international characters.

[global]
        # TDS protocol version
        #tds version = 4.2
        tds version = 8.0
        client charset = UTF-8