@CRMSigns, thank you for your answer
I have replay my migration from 7.6.7 now to 7.11.23 because in this version elasticsearh was introduced and can be activated. The thing were better but the problems with the spanish special characters persist.
I found this PR https://github.com/salesagility/SuiteCRM/issues/7919 related with my problem. I have merged this commit https://github.com/Dillon-Brown/SuiteCRM/commit/7c6dc9488df1ef9b19294c4748929dd422bbd401 and now I’m able to get good results when searching in console with Robo but those results are ugly when making the same search in UI with the global search.
These are my results serachig for “Natalia Muñoz Saavedra” in console with Robo.
root@azucar:/var/www/sugarcrm# php vendor/bin/robo -vvv elastic:search "Natalia Muñoz Saavedra"
Results
=======
Leads
-----
* Natalia Muñoz Saavedra
* Natalia Natalia
* Angelika Natalia
* Natalia Muñoz
* Natalia Muñoz
* Natalia Muñoz
* Natalia Muñoz
* Natalia Ramirez Saavedra
* Natalia MartĂn Saavedra
* Natalia Muñoz Muñoz
* Natalia
* Carlos Saavedra
* Vanesa Saavedra
* EstefanĂa Saavedra
* Natalia Muñoz Villalón
* Natalia Muñoz Urdiales
* Natalia Muñoz Fernández
* natalia muñoz liñán
* Natalia Muñoz Valdés
* Natalia GarcĂa Muñoz
[OK] Search performed in 29 ms
And that is what I get searching with the UI.
I have no idea about especial tuning in elasticsearch motor but I think the problems are in SuiteCRM. I think that multinational companies works with special characters on many languages at the same time and utf8 now support that and Basic Global Search deals well with this (but it is slow)… in fact my search results are good when searching with robo in console.
I didn’t make tests with SuiteCRM 8 because at the moment there’s no path to upgrade there from previous versions.