Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Values getting cropped when stored in Dynamic Data Store (tblBigTable)
I think there is a misunderstanding somewhere. Indexed_String01 is only nvarchar(450). it's not possible to have index on columns that are combined > 900 chars
Oct 26, 2023 13:13
Tam Duc Ha Vo
- Oct 26, 2023 13:16
Ah, I see. We have annotated the attribute with [EPiServerDataIndex]. Maybe if we remove that the value will not be cropped?
Yes, when you add that attribute it tells DDS to use the indexed column. I think the API truncates the values automatically. You should use the non indexed column (it's nvarchar(max)), it does not make senses to index a 4000+ length column anyway
Edited,
Oct 26, 2023 13:45
Tam Duc Ha Vo
- Oct 26, 2023 13:47
I see. How will the remap happen for existing rows in the table if I remove the attribute [EPiServerDataIndex]?
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
Hi, we have a column Indexed_String01 in tblBigTable with a varchar(8000), but when we store a string, it gets cropped even though the string is less than 8000 characters. Any idea why this happens?