I'm not 100% sure on the limit number but I seem to remember seeing a post about one. There's a simple workaround that I can think of and it's how we store a lot of data in the meta fields
This works as I'm doing it for complex storage types.
Hi Scott.. i need separate nvarchar meta fields for my particular requirement, but now that there already are so many nvarcahr columns in the contact table, it won't let me create fields if they go beyonf 100 characters. Can we change this restriction somewhere?
Not that I know of, hopefully someone from Episerver will see this and give a definitive answer.
I’m working with Episerver Commerce 10.0. I’m trying to create new meta fields in the Business Foundation Contact class. This already has over 40 text fields. I add a new text field of size 255 and it creates successfully. But then it won’t let me create any more text fields. I then removed the first field and created it again, this time of size 100.. it creates successfully. I’m then able to add 2 more text fields of size 100, but then it won’t let me create a fourth.. which makes me feel that there is some sort of size/column restriction on contact tables. Is that correct? Is there a way to increase this size/ manage this restriction? If so, where and how? I’m doing all of this through Commerce Manager interface.
I’m in urgent need of a solution here, as it’s hampering work. Please advise.