Skip to content


DBAL-184: bigint binding problems in sqlite3 #1354

doctrinebot opened this Issue · 2 comments

2 participants


Jira issue originally created by user mw:

I created a @Column that was type "bigint" and when inserting very large numbers, they were getting capped in SQLite3 at 2147483647.

I switched Doctrine/DBAL/Types/BigIntType.php, line 46 from:

return \PDO::PARAM_INT;


return \PDO::PARAM_STR;

and now it is storing the full numbers. I am unsure, however, whether this is the right change or will affect other database layers. Any thoughts?



Comment created by @beberlei:



Issue was closed with resolution "Fixed"

@doctrinebot doctrinebot added the Bug label
@beberlei beberlei was assigned by doctrinebot
@doctrinebot doctrinebot added this to the 2.1.6 milestone
@doctrinebot doctrinebot closed this
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.