Any ideas how easily to make the change so as not to interrupt the data - I guess it will need to be encoded properly?
This works great for those GROUP_CONCATs that convert your output to blobs and you really want them as strings.
It works through annotations and can update fields on creation, update, property subset update, or even on specific property value change.
PHP 7.1 is very new, and adds many amazing new features over the older 5.x versions.
The engine has been largely re-written, and PHP is now even quicker than older versions.
Would you like to answer one of these unanswered questions instead?
Blameable behavior will automate the update of username or user reference fields on your Entities or Documents.
I have a whole lot of records where text has been stored in a blob in My SQL.
For ease of handling I'd like to change the format in the database to TEXT...Similarly in my recent years I used to believe that it wasn't possible to use multiple databases with relationships with Symfony2 and Doctrine2, however the modern, wiser me no longer believes in the existence of blood sucking pale corpses, and similarly now knows that one can have multiple databases within a Symfony2/Doctrine2 app. You will need to use only connection that spans all of your databases, if you want to build a relationship between entities then they must use the same connection.Do to this you will need a user that has access to all of the databases the you wish to access.I had an issue similar to the OP's while using Node.JS with the node-mysql library - this fixed all group_concat issues.ALTER TABLE mytable ADD COLUMN field1_new TEXT NOT NULL, ADD COLUMN field2_new TEXT NOT NULL; update mytable set field1_new = CONVERT(field1 USING utf8), field2_new = CONVERT(field2 USING utf8); alter table mytable drop column field1, drop column field2; alter table mytable change column field1_new field1 text, change column field2_new field2 text; Thank you for your interest in this question.