Define the maximum size of content fields

Last updated:
Edit on GitHub

By default, the CMS module doesn’t specify the content field’s size. For MySQL and MariaDB, it is transferred to TEXT (65535 bytes), and for PostgreSQL, it is transferred to TEXT (unlimited length).

If your project requires more, you can redefine the field’s size in the spy_cms_version table.

For example, place the following into src/Pyz/Zed/Cms/Persistence/Propel/Schema/spy_cms.schema.xml:

<div code="xml">
	<?xml version="1.0"?>
	<database xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="zed" xsi:noNamespaceSchemaLocation="http://static.spryker.com/schema-01.xsd" namespace="OrmZedCmsPersistence" package="src.Orm.Zed.Cms.Persistence">
		<table name="spy_cms_version">
			<column name="data" type="LONGVARCHAR" size="4294967295" />
		</table>
	</database>
</div>