3 ms·
>Since text fields in mysql are stored as separate files Bwuh? Over in MS SQL you just go for an NVARCHAR and forget about it. What is the right way to store t
by voltagex_ 10y ago
>Since text fields in mysql are stored as separate files
Bwuh? Over in MS SQL you just go for an NVARCHAR and forget about it. What is the right way to store this data (if you really do need to store the JSON rather than just serializing it again when you get it out of the DB)
- chewbacha 10y agovarchar is different than a text field in mysql: http://dev.mysql.com/doc/refman/5.7/en/blob.html http://dev.mysql.com/doc/refman/5.7/en/blob.html It stores text fields as blobs. I suppose now the right way would be the json data type. It didn't exist when I was working with these servers though (or they were on a much older version of MySql) https://dev.mysql.com/doc/refman/5.7/en/json.html https://dev.mysql.com/doc/refman/5.7/en/json.html