Translations in the Location Table

[danielrueckert]

Our client has requested that entries in the cmn_location table be translated.

Please note that the values in the Name, State/Province, and Country fields require translation.

To do so, I would need to change the data type of the fields from "String" to "Translated Text". The table is currently empty, so there should be no problems, but I cannot currently estimate whether changing the data type could cause other problems. I would appreciate your input on the feasibility of implementing this change and whether there are any potential issues I should be aware of?

Or is there another way to translate these values that I am currently overlooking?

[Alex Coope - SN]

Hi @danielrueckert,

Typically, yes it would be a case of changing the field type from "string" to "translated_text". When something like the location values are changed, be mindful that going down this route, every language should have entries otherwise reference qualifiers on fields pointing to this table may not work properly, and conversely any filtering of entries on this table might need adjusting because they might be holding English labels rather than server-side values.

So, in summary if you do this, I'd strongly suggest doing it on a safe sub-prod, and thoroughly testing it as much as you can in various parts of the platform,

Many thanks,

kind regards