We recently upgraded from 3.4 to 4.0 in our (neglected) lab, and after the upgrade, the UI had this error in the system info (see pic). ongoing commercial projects in thane
I double checked and sure enough, Zabbix likes collation `utf-bin8` and we have `utf8_general_ci` on every table. dombivali east property
I ran this command for each real estate advisory services table: `ALTER TABLE 'acknowledges' convert to character set utf8 collate utf8_bin;` which, predictably, took a while for the larger tables. luxury flats for sale in mumbai
Then the errors went away immediately! But I wonder, is this a proper solution? Things seem to be working okay since then. real estate developers in mumbai
I double checked and sure enough, Zabbix likes collation `utf-bin8` and we have `utf8_general_ci` on every table. dombivali east property
I ran this command for each real estate advisory services table: `ALTER TABLE 'acknowledges' convert to character set utf8 collate utf8_bin;` which, predictably, took a while for the larger tables. luxury flats for sale in mumbai
Then the errors went away immediately! But I wonder, is this a proper solution? Things seem to be working okay since then. real estate developers in mumbai