On 03.06.23 18:06, Mark Edwards wrote:
child says:
`provider` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_*general*_ci NOT NULL,

parent says:
`provider` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_*unicode*_ci NOT NULL,

notice collate does not match?  mariadb is very particular on how the keys have to match up perfectly.


I missed the start of this thread, but this problem looks like

https://jira.mariadb.org/browse/MDEV-31086

to me.

--
Hartmut Holzgraefe, Principal Support Engineer (EMEA)
MariaDB Corporation | http://www.mariadb.com/


_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to