So I'm caching the descriptions of games locally for faster loading and for most of the games I noticed a mediumtext field type works fine.
But there's some games out there with a big-ass description, such as World of Warcraft or Star Wars the Old Republic. The values of these descriptions were truncated in the database, resulting in the HTML being broken when displayed.
Now I have set the field type to longtext but the difference between mediumtext and longtext is incredibly big, look at these values:
mediumtext: 16777215 maximum characters
longtext: 4294967295 maximum characters (source)
How does one best go about solving this? Keeping it at longtext? Or is there another (better) way of achieving the saving of this data?
Log in to comment