Solution: Change the language of existing content objects

eng-GB -> eng-US

Convert from eng-GB to eng-US

UPDATE ezcontentobject_name
 SET
   content_translation='eng-US',
   real_translation='eng-US'
 WHERE
   content_translation='eng-GB' AND
   real_translation='eng-GB';

eng-GB -> ger-DE

Convert from eng-GB to ger-DE

UPDATE ezcontentobject_name
 SET
   content_translation='ger-DE',
   real_translation='ger-DE'
 WHERE
   content_translation='eng-GB' AND
   real_translation='eng-GB';
 
 UPDATE ezcontentobject_attribute
 SET
   language_code='ger-DE'
 WHERE
   language_code='eng-GB';
 
 UPDATE ezcontent_translation
 SET
   locale='ger-DE',
   name='Deutsch (Deutschland)'
 WHERE
   locale='eng-GB';

External Reference

• How can I change the language of existing content objects?