Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

xtopher's avatar

MYSQL and MariaDB

How do I make the json column of MySQL compatible with MariaDB I have mariadb 10.4.8 and also which is better for laravel projects

0 likes
4 replies
TerrePorter's avatar

@xtopher what do you mean when you say image the json column? Its either or for the second question, as far as I know the code base hasnt drifted apart enough to matter currently.

willvincent's avatar

As far as I'm aware, Maria's json column type is compatible with mysql's json column type, and has been since mariadb 10.2.something

"better" is subjective.. at the end of the day the only real notable difference between Mysql and maria is maria is fully open source, community-driven, whereas mysql is owned and managed by oracle.

xtopher's avatar

somehow the querying the database isn't working because i keep getting Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'meta->' $."price" I tried changing the migration file to LONGTEXT but still not working

Please or to participate in this conversation.