https://www.percona.com/blog/cant-we-assign-a-default-value-to-the-blob-text-geometry-and-json-data-types/ Fri, 12 Jan 2024 15:25:38 +0000 hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/cant-we-assign-a-default-value-to-the-blob-text-geometry-and-json-data-types/#comment-10974247 Fri, 12 Jan 2024 15:25:38 +0000 https://www.percona.com/blog/?p=93471#comment-10974247 That the default values have to be an expression seems a bit unnecessary, although using expressions is a fair workaround. Literal default values for blob and text columns have been supported in MariaDB since 10.2.1. I’m sure MySQL will support this as well one day.

]]>