Laravel's JSON table migration data type length?

I can't seem to find this in the official documentation, but perhaps I'm being blind.

What is the length of the JSON data type in Laravel? I am currently saving JSON as TEXT however it has reached the 65,000 limit.

I could use LONGTEXT but I noticed the JSON data type and thought this might be better.

MichalOravec

5 years ago

Best Answer

Level 75

In general, the storage requirement for a JSON column is approximately the same as for a LONGBLOB or LONGTEXT column. And LONGTEXT limit is 4 294 967 296.

Docs: https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html#data-types-storage-reqs-json (look for JSON Storage Requirements)

4 likes

Please or to participate in this conversation.