Try our conversational search powered by Generative AI!

Values getting cropped when stored in Dynamic Data Store (tblBigTable)


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?

Oct 26, 2023 11:54

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]?
Quan Mai - Oct 26, 2023 13:52
I have no idea. I suppose you'll have to migrate those rows yourself
Tam Duc Ha Vo - Oct 26, 2023 14:18
Alright, thank you!
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.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.