DBAL-759: [GH-489] Fix driver error while introspecting sequences in SQL Server 2012 #1987

doctrinebot opened this Issue Jan 2, 2014 · 2 comments

2 participants


Jira issue originally created by user @doctrinebot:

This issue is created automatically through a Github pull request on behalf of deeky666:

Url: #489


It seems the SQL Server drivers don't like SQL Server's special sql_variant data type when retrieving data from such columns. Therefore introspecting Sequences in SQL Server 2012 generates the following error:

Fatal error: Unexpected SQL type encountered in calc*string*size. in C:\cygwin\home\Administrator\dev\dbal\lib\Doctrine\DBAL\Driver\SQLSrv\SQLSrvStatement.php on line 226

A workaround this limitation is to cast the specific columns to VARCHAR in the query.


Comment created by @doctrinebot:

A related Github Pull-Request [GH-489] was closed:


Issue was closed with resolution "Fixed"

@doctrinebot doctrinebot added the Bug label Dec 7, 2015
@beberlei beberlei was assigned by doctrinebot Dec 7, 2015
@doctrinebot doctrinebot added this to the 2.4.3 milestone Dec 7, 2015
@doctrinebot doctrinebot closed this Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment