Size of entity Name column with multi-language
I am developing a site which will be deployed with 11 different languages. If I assume that entity names (category, manufacturer, section, genre & product) are 50 characters each then I'll need the Name column to be an nvarchar(900). Currently it is just 400.
This also has a knock-on effect onto the index (e.g. IX_Category_Name). Is there any point having an index on the Name column anyway if the data is stored in the ML XML format?
Has anyone any experience with an AspDotNetStorefront site in so many languages?