In Drupal, all data (including the translations) are stored via a content type is a node. When using Drupal translations, the nodes are stored in a database just like in the case of a general data. In some cases, they may be stored in multiple database tables, yet the main pieces of data storing are the nodes stored in databases.
We've received this query on our website, and we've wanted to set this problem once and for all. So, just remember that in Drupal nodes translations are well...still nodes, and are stored just like normal Drupal nodes.
Nodes combination and linking
It’s actually a combination of nodes, stored with the help of IDs in databases. In any case, all content and its corresponding translations are stored as nodes in node table(s).
When it comes to the main general procedure of data translation, the problematic is a bit more complicated and it depends on the Drupal version you are using.
There are two main ways to do translations: the content translation module and the entity translation module. Drupal 8 came with a promise to do the node translation procedure even easier, for both devs and contents.
Now, from the two main translation modules available, only the Entity reference variant remained standing. The content translation module became obsolete, so if you’ve been using it, you may want to make some changes in your website’s modules structure.
When it comes to multilingual websites, Drupal 7 multilingual websites still use Content Translation and Entity translation to ensure that the translations are properly assigned. For years, making a website multilingual was a true challenge for all developers, thing partially solved by Drupal 8.
In Drupal 8 the Entity translation module was included in the core. So, for this Drupal version, you will not have to work as much as in the case of the others. The best part for this version is that the string translation of the interface has already been done (and it's a great translation we may add).
This is a great improvement from the latest versions as the community really did a great work on translation the administration interface.
Also read the Multilingual guide on Drupal official website for more info.
If you have more questions, don't hesitate to contact us in the comment section below or in our the contact form.
Cheers and keep on translating!