library zf2doctrine2sqlsrv
ZF2 Module which integrates Sqlsrv specific types for the doctrine2 DBAL
maegnes/zf2doctrine2sqlsrv
ZF2 Module which integrates Sqlsrv specific types for the doctrine2 DBAL
- Wednesday, November 26, 2014
- by maegnes
- Repository
- 1 Watchers
- 0 Stars
- 17 Installations
- PHP
- 0 Dependents
- 0 Suggesters
- 0 Forks
- 0 Open issues
- 1 Versions
- 0 % Grown
, (*1)
ZF2Doctrine2SqlsrvTypes
If you are working with Microsoft MSSQL and its "Sqlsrv"-Driver with Zend Framework2 and Doctrine2 you will
have some troubles with the "datetime" and "date" types in Doctrine2. The MSSQL-Server doesn't accept the defined standard
format "Y-m-D H:i:s" or "Y-m-D" in Doctrine2., (*2)
To avoid problems with the format use the ZF2Doctrine2SqlsrvTypes module which integrates the two new DBAL Types SqlsrvDatetime and SqlsrvDate., (*3)
After installing the module via composer just replace the types in your doctrine2 notation from "datetime" to "SqlsrvDatetime" and
from "date" to "SqlsrvDate"., (*4)
Installation via Composer
Just add the following dependency to your composer.json file and add the module "ZF2Doctrine2SqlsrvTypes" to your modules list
in the application.config.php., (*5)
{
"require": {
"maegnes/zf2doctrine2sqlsrv": "dev-master"
}
}