DBAL-42: Use column comments for further Doctrine Type Inference #1614

doctrinebot opened this Issue Aug 12, 2010 · 4 comments

2 participants


Jira issue originally created by user @beberlei:

Any custom type could use vendors column comment functionalities to allow more details on the specific type of a column that can be used inside the "listTableColumns()" method.


Comment created by @beberlei:

MySQL, postfix column with "COMMENT 'The KEY obviously'"

Postgres, COMMENT syntax (another SQL statement, narf!): http://www.postgresql.org/docs/8.3/static/sql-comment.html

Oracle, COMMENT syntax (another SQL statement): http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_4009.htm

Sqlite: Nada

Mssql: (woah this is ugly) http://msdn.microsoft.com/en-us/library/ms180047.aspx


Comment created by @beberlei:

Implemented for Oracle, PostgreSQL and MySQL.

Now for Array and Object types a Column Comment is appended of the format "(DC2Type:$type)" which is parsed when reading from the database.


Issue was closed with resolution "Fixed"

@beberlei beberlei was assigned by doctrinebot Dec 6, 2015
@doctrinebot doctrinebot added this to the 2.1 milestone Dec 6, 2015
@doctrinebot doctrinebot closed this Dec 6, 2015
@cmodijk cmodijk referenced this issue in greydnls/doctrine-additions Mar 30, 2016

Add requiresSQLCommentHint #1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment