Download the PHP package prefeituravitoria/mssql-bundle without Composer
On this page you can find all versions of the php package prefeituravitoria/mssql-bundle. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download prefeituravitoria/mssql-bundle
More information about prefeituravitoria/mssql-bundle
Files in prefeituravitoria/mssql-bundle
Package mssql-bundle
Short Description Microsoft SQL Server Bundle for Symfony 2
License MIT
Informations about the package mssql-bundle
Installation
Step 1. Install MssqlBundle
Add the prefeituravitoria/mssql-bundle into composer.json
"require": {
....
"prefeituravitoria/mssql-bundle": "master-dev"
},
And run
Step 2. Configure DBAL's connection to use MssqlBundle
In config.yml, remove the "driver" param and add "driver_class" instead:
Step 3. Enable the bundle
Finally, enable the bundle in the kernel:
Notes
Prerequsites
Microsoft SQL Server 2012.
This driver requires version 8.0 (from http://www.ubuntitis.com/?p=64) as default 4.2 version does not have UTF support
In /etc/freetds/freetds.conf, change tds version = 4.2 to tds version = 8.0
NVARCHAR & NTEXT data types
NVARCHAR & NTEXT are not supported. In SQL 2000 SP4 or newer, SQL 2005 or SQL 2008, if you do a query that returns NTEXT type data, you may encounter the following exception: _mssql.MssqlDatabaseError: SQL Server message 4004, severity 16, state 1, line 1: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.
It means that SQL Server is unable to send Unicode data to FTREETDS, because of shortcomings of FTREETDS. You have to CAST or CONVERT the data to equivalent NVARCHAR data type, which does not exhibit this behaviour.