Description
| Q | A |
|---|---|
| Sulu Version | 3.0 |
| PHP Version | 8.4 |
| DB Version | Postgres 16.6 |
| Browser Version | - |
Actual Behavior
A new issue I have just run into - in the ar_article_dimension_contents table there is the title column defined as character varying(64) NULL - this is very short for an article title.
From @alexander-schranz
Think the maximum would be 191 chars. As the title column is searchable and there and by default indexes on utf8mb4 can on different mysql versions not be longer as 191 chars.
Interesting history about that number, it was 255 but mysql internal only used 3 bytes to to store utf8 chars. Which worked well many years until Emojis appeared which did make utf8 implementation of mysql crash. And to support that the implemented utf8mb4 which max indexes size is 191 instead of 255.
Alex has also suggested:
For all other cases I recommend additional
pageTitlefield which may is atext_areainstead oftext_linefield even.
Expected Behavior
I would suggest we increase the size of this column to 191 characters.