maria-discuss team mailing list archive

[Alex Regan <mysqlstudent@xxxxxxxxx>]

Hi,

On 6/5/23 6:07 AM, Hartmut Holzgraefe wrote:
> 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

Yep, that's it. Thanks so much. I suspect by the next time I need this 
backup for my test server, it'll have been fixed upstream.

Thanks also to Mark Edwards for his awesome support.