DDC-24: text type not portable (works only on MySQL) #31

New Issue

admin · 2026-01-22T12:24:51+01:00

admin commented

2026-01-22 12:24:51 +01:00

Originally created by @doctrinebot on GitHub (Sep 30, 2009).

Jira issue originally created by user itoijala:

The text type is not portable to other RDBMS than MySQL. To support the text type, a platform must implement the method getClobDeclarationSql(array $field). Currently only MySqlPlatform has this method. This means that attempting to use the CLI tool to create a schema with a text column using another RDBMS fails with the following error:

Fatal error: Call to undefined method Doctrine\DBAL\Platforms\SqlitePlatform::getClobDeclarationSql() in D:\Projects\Test\tools\sandbox\lib\Doctrine\DBAL\Types\TextType.php on line 15

I believe at least Sqlite supports the CLOB type.

Either the text type should be supported by all platforms or the documentation should be revised. Currently it says:

"All Doctrine Mapping Types that ship with Doctrine are fully portable between different RDBMS."

This makes easy testing of models using sqlite with minimum configuration impossible with the text type.

Originally created by @doctrinebot on GitHub (Sep 30, 2009). Jira issue originally created by user itoijala: The text type is not portable to other RDBMS than MySQL. To support the text type, a platform must implement the method getClobDeclarationSql(array $field). Currently only MySqlPlatform has this method. This means that attempting to use the CLI tool to create a schema with a text column using another RDBMS fails with the following error: Fatal error: Call to undefined method Doctrine\DBAL\Platforms\SqlitePlatform::getClobDeclarationSql() in D:\Projects\Test\tools\sandbox\lib\Doctrine\DBAL\Types\TextType.php on line 15 I believe at least Sqlite supports the CLOB type. Either the text type should be supported by all platforms or the documentation should be revised. Currently it says: "All Doctrine Mapping Types that ship with Doctrine are fully portable between different RDBMS." This makes easy testing of models using sqlite with minimum configuration impossible with the text type.

admin added the Bug label 2026-01-22 12:24:51 +01:00

admin closed this issue

2026-01-22 12:24:52 +01:00

admin commented

2026-01-22 12:24:52 +01:00

@doctrinebot commented on GitHub (Sep 30, 2009):

Comment created by romanb:

Thanks. We will try to address this as soon as possible. This is just an oversight in the implementation. The text type can definitely be made portable across all platforms.

@doctrinebot commented on GitHub (Sep 30, 2009): Comment created by romanb: Thanks. We will try to address this as soon as possible. This is just an oversight in the implementation. The text type can definitely be made portable across all platforms.

admin commented

2026-01-22 12:24:53 +01:00

@doctrinebot commented on GitHub (Oct 1, 2009):

Issue was closed with resolution "Fixed"

@doctrinebot commented on GitHub (Oct 1, 2009): Issue was closed with resolution "Fixed"

admin referenced this issue

2026-01-22 15:56:01 +01:00

[PR #31] [CLOSED] Fix typos #7614

Sign in to join this conversation.