Updating database default language

[Xavi]

Hi, im running into the same issue described in this post: Translate field property doesn't work in Spanish as in English.
The solution given there is to define the main language of the database, but some time ago I got this answer in this forum asking about another thing:
"
This is stored in the database and can no more be changed once the database has been setup. But it is actually the default language that the cron task will be using.
"
If just changing the value in the config won’t work, is there any way to actually change the language? maybe creating a new database with the desired language and then migrating all the data? would it cause trouble with existing data?

Thanks in advance.

[alejandro (Alejandro Ayala Usuga)]

Greetings.

You can define the main language using the wizards in the administration section of tryton. Are you trying to change the language of the entry database?.

Now you can set your preference language in the user configuration.

For fields like:

Product Name that is field “translate=True” you can override this value.

How could I replicate this error?

[ced (Cédric Krier)]

The default language is stored as language in the table ir_configuration of the database.
Normally it is not allowed to change it because it defines which value of translated fields are stored in the main table and the other in ir_translation. So if you change it after you may have inconsistency in the translated data. So it is at your own risk.