I fixed the length calculation when the excerpt contains details blocks:
FIX: Calculation of text length for <details> in excerpt was wrong · discourse/discourse@d243b82 · GitHub
There’s still a chance that lots of small details blocks or a combination of other HTML tags could bring you over the 1000 character limit, but it’s a lot less likely. Fixing this completely would require removal of the column’s length limit.