“It's The Future”

Re:“It's The Future” by voltagex_ on Wednesday August 17, 2016 @10:36AM (#12305013)

>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)

[ Parent | on HN ]

Re:“It's The Future” by chewbacha on Wednesday August 17, 2016 @10:57AM (#12305172)

varchar is different than a text field in mysql: 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

[ Parent | on HN ]