News for hackers. Stuff that matters.

A comment on In MySQL, use “utf8mb4” instead of “utf8” (2016). Parent comment

Re:In MySQL, use “utf8mb4” instead of “utf8” (2016) by Ginden on Wednesday January 12, 2022 @02:08PM (#29911425)
> Silent truncation only occurs if strict sql_mode is disabled. Strict sql_mode has been the default since MySQL 5.7, released over 6 years ago.

What happens if you upgrade from older version? Are defaults from previous version used, or is it default only on fresh installs?

[ Parent | on HN ]
Re:In MySQL, use “utf8mb4” instead of “utf8” (2016) by johannes1234321 on Wednesday January 12, 2022 @03:28PM (#29912283)
If you don't have an explicit value set in your my.cnf config and the client sends no explicit value upon connecting you get the current built in default of the version you are using. If you set something somewhere it will be respected.
[ Parent | on HN ]
Re:In MySQL, use “utf8mb4” instead of “utf8” (2016) by evanelias on Wednesday January 12, 2022 @02:21PM (#29911575)
See bottom of https://news.ycombinator.com/item?id=29910494 and my reply https://news.ycombinator.com/item?id=29910863
[ Parent | on HN ]