This site has been archived and you can no longer log in or post new messages. For up-to-date community resources please visit

eZ Community » Forums » Developer » Change site language in database

Change site language in database

Change site language in database

Monday 18 February 2013 4:36:47 pm - 4 replies

I am working on a website for UK and we have made the mistake to create the content classes and content objects in eng-US, as it was also an English language and didn't really pay much attention on this aspect. It seems like we will have to change the whole site to eng-UK as the client was not that happy about it and put the magic question: "And what do you think I will do if I want to later get a version for US with slightly different content? It would be too confusing for my editors."
Can anybody tell me a good solution for how can I automatically change the language of all content objects to eng-UK?
I have tried to change the language masks and other language refernces in tables ezcontentobject, ezcontentobject_attribute, ezcontentobject_nameĀ  from DB, but then my root became invisible and the whole Content structure tag disapeared. On setup / language seemed that every object is translated.
Thanks a lot in advance for any help.

Monday 18 February 2013 9:11:19 pm

Maybe an easy way out:

- in admin interface, add both languages: eng-us and eng-uk

- in ezcontentlanguage table, swap ids of the two englishes

Monday 18 February 2013 9:13:25 pm

Or you can just alter the locale definition + the icon for eng-us, so that it shows up as something else...

One note though: when using eng-uk, template translation is always disabled. This is way people who want to have "real english" content often "invent" new english-lookalike locales...

Thursday 21 February 2013 11:10:44 am

Thank you Gaetano. We switched id's after that updated where eng-UK was in the database.

Thursday 21 February 2013 11:12:55 am

Thank you Gaetano. We switched the id's, updated eng-UK in database and it is working ok.


You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu

Proudly Developed with from