Fixed MySQL exception when searching a user with EMOJI UTF8MB4

[Jean-Baptiste]

Affected version

2.0.1

Hello,

Please find an example :

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

When you use the admin quick search form, with as an example : "" as a search term, a MySQL error will occur.

Thanks

 

[Chris D]

I can confirm this - it relates to us attempting to convert an input to utf8 which we do generally for case insensitive searching. Problem is, that needs to be switched to converting to utf8mb4 if fullUnicode is enabled.

 

[Chris D]

@Kier just zapped this and several others for the next release. Thanks.