MySQL Select with Where on a View calculated column results in Illegal mix of collations

Woocommerce, creating a view that wraps HTML around post_status, so post_status is now calculated column (yes stupid wordpress is ignoring newlines in the pasted SQL snippet)

,concat(
case
when coalesce(mecha_note, '') <> ''
then '
' else '' end, case when post_status like '%cancel%' or post_status like '%refund%' then concat('', post_status, '') when post_status like '%completed%' then concat('', post_status, '
') else post_status end, case when coalesce(mecha_note, '') <> '' then concat('Fulfillment note:

', mecha_note, '
')
else '' end
) as post_status

PHP -> SQL filtering by status errors:

select * from vOrdersList
where post_status <> 'wc-completed'
and post_status <> 'wc-cancelled'
and post_status <> 'wc-refunded';

Error Code: 1267. Illegal mix of collations (utf8mb4_bin,NONE) and (utf8_general_ci,COERCIBLE) for operation 'like' 0.235 sec

What is the collation of the original posts table source column:

select COLLATION(post_status) as post_status, 
COLLATION(user()) as user_func,
COLLATION(substring_index(user(), '@', 1)) as substr_func
from wp1_posts;

post_status, user_func, substr_func
'utf8mb4_unicode_ci', 'utf8_general_ci', 'utf8_general_ci'

What about the calculated column in the view?

select COLLATION(post_status) as post_status, 
COLLATION(user()) as user_func,
COLLATION(substring_index(user(), '@', 1)) as substr_func
from vOrdersList;

post_status, user_func, substr_func
'utf8mb4_bin', 'utf8_general_ci', 'utf8_general_ci'

My solution: set collation for the calculated column in the view to match the source column, revised view for that column (see last line)
(yes stupid wordpress is ignoring newlines in the pasted SQL snippet) :

 ,concat(
case
when coalesce(mecha_note, '') <> ''
then '
' else '' end, case when post_status like '%cancel%' or post_status like '%refund%' then concat('', post_status, '') when post_status like '%completed%' then concat('', post_status, '
') else post_status end, case when coalesce(mecha_note, '') <> '' then concat('Fulfillment note:

', mecha_note, '
')
else '' end
) collate utf8mb4_unicode_ci as post_status