Try our conversational search powered by Generative AI!
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?