Accent insensitive search with MYSQL not working

i changed the collation as mentioned earlier. there is no difference in the nopcommerce functionality after that though.
are you telling me that you have it working or why are you trying to persuade me that it is a matter of collation setting?
i insist it is a bug of nopcommerce

I don't have MySQL currently installed on my dev PC.  However, I did this in SQL Server and it worked.
(0 = no rows found;  1 = 1 row found)

SELECT top 10 *
 into x_temp_product  
  FROM [Product]
GO

update x_temp_product set Name = Name + 'výfuk' where Id = 1
GO

select * from x_temp_product where Name LIKE '%vyfuk%';
--0
select * from x_temp_product where Name LIKE '%výfuk%';
--1
select * from x_temp_product where Name = (select Name from x_temp_product where Id = 1)
--1
GO

ALTER TABLE x_temp_product
  ALTER COLUMN Name VARCHAR(50) COLLATE Latin1_General_100_CI_AI_SC_UTF8
GO

select * from x_temp_product where Name LIKE '%vyfuk%';
--1
select * from x_temp_product where Name LIKE '%výfuk%';
--1
GO

then its mysql specific thus a bug

btw you have proven nothing with your steps as it is exactly what i posted in the OP that it works under the sql server itself but it does not work in the app

Previously you said

select * from Product where Name LIKE "%vyfuk%";
which gives the expected results

You are using double quotes  ( "  ... " )
Try it using single quotes:

select * from Product where Name LIKE '%vyfuk%';

it is same with single quotes - i get the results for both accented word and without accent
i dont get any results in nopcommerce search though when using words without accent.
as mentioned few times already

> select name from Product p where Name LIKE '%vyfuk%' LIMIT 5

name                                                                                                      |
----------------------------------------------------------------------------------------------------------+
výfukové koleno Redukcia 25/28mm pre Minarelli AM, Generic, KSR-Moto, Keeway, Motobi, Ride, 1E40MA, 1E40MB|
Tesnenie výfuku  25x38x4mm pre maxi scooters                                                              |
Tesnenie výfuku  kruh verzia 35x43.5x5.3mm                                                                |
Tesnenie výfuku  kruh verzia 30x39x4mm                                                                    |
Tepelný štít výfuku pre 101 Octane exhaust                                                                |

5 row(s) fetched.

> select name from Product p where Name LIKE '%výfuk%' LIMIT 5

name                                                                                                      |
----------------------------------------------------------------------------------------------------------+
výfukové koleno Redukcia 25/28mm pre Minarelli AM, Generic, KSR-Moto, Keeway, Motobi, Ride, 1E40MA, 1E40MB|
Tesnenie výfuku  25x38x4mm pre maxi scooters                                                              |
Tesnenie výfuku  kruh verzia 35x43.5x5.3mm                                                                |
Tesnenie výfuku  kruh verzia 30x39x4mm                                                                    |
Tepelný štít výfuku pre 101 Octane exhaust                                                                |

5 row(s) fetched.

to be clear I am reporting a bug in nopcommerce code here, not requesting mysql assistance

8 months later.
any fix for this nonsense behavior in the newer versions? do i need to updgrade for this functionality?