Adding JSON type field in table

[expired user #11831]'s profile image [expired user #11831] posted 6 years ago in General Permalink

Trying to add a JSON field to a table. Keep getting a 1064 error - see attachment. Just trying to create a new table in HeidiSQL.

1 attachment(s):
  • mysql-error-for-json-type-fields
ansgar's profile image ansgar posted 6 years ago Permalink

Perhaps your server does not yet support JSON columns. You should post more details about your setup here.

[expired user #11831]'s profile image [expired user #11831] posted 6 years ago Permalink

Ok so I am still getting this error. I had tried a few other things but I am back trying to add the JSON type column.

My MySQL is hosted on SiteGround. Not sure what else you need to figure out why I can;t create this type.

[expired user #11831]'s profile image [expired user #11831] posted 6 years ago Permalink

Alright - after at least 30 mins on with SiteGround - they said it's version 5.6. So yep doesn't support JSON. Any suggestions on other hosting for MySQL with 5.7 or higher?

Please login to leave a reply, or register at first.