Build SQL task changes the size of culture columns
|Category:||Data model / ORM|
|Target version:||Release 2.6.0|
|Google Code Legacy ID:||Tested version:||2.5, 2.6|
Each time a change is introduced in the models schema (YML file) the following tasks have to be executed to generate the database schema (SQL file) used on the install process to create the AtoM datase and the base model classes.
php symfony propel:build-sql php symfony propel:build-model
On #9051, the size of the culture columns was increased from 7 to 16 chars directly on the SQL schema (related commit), which causes its modification back to 7 chars each time the
build-sql task is executed.
Additionally, this columns are added automatically by Symfony based on the
_i18n tables, so changing it's size may cause other issues. For example, the languages form on the settings page validates the culture selected internally with this function, which validates the culture value using a regular expression and also looks for a data file on this folder. So, to be fair, I don't really know how the "ca@valencia" culture even works.