The spiting of tables for multilingual is only supported for newly added languages the old language related data will remain in a single table.
To explain the difference between single table storage and split tables:
Single table storage
: all language related data will be stored in a single table for example sf_news_items
table stores the data for news items and language related data like Title, URL, Summary in french are stored as additional columns in this table making the table columns increase in number. SQL server have a limitation for maximum 1024 columns in a single table so the formula to calculate the
the number of Lstring fields
* number of cultures
+ additional fields
of the current type. This number must not exceed 1024.
: a new table is created for each added to the site after split tables are enabled using foreign keys to make a reference to each language version of the item.
The already created data in the site will remain in single tables even if a particular culture is deleted, split tables are enabled and this culture is added again. This is because when a culture is deleted the columns with the culture related data remains in the DB.
Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking
system and vote to affect the priority of the items