What alternative to Sql_latin1_general_cp1251_cs_as in Mysql

Question

What would be an alternative, in Mysql, for COLLATION Sql_latin1_general_cp1251_cs_as for Mysql or how to remove the accent from a string (or for any table or column) using commands?

Reference:

https://www.dirceuresende.com/blog/como-remover-acentuacao-e-caracteres-especiais-de-uma-string-no-sql-server/