Accented characters in entities search
In AJAX entities search, not consider accented characters.
For example, if I search e show entities where e, é, è, ... in their name.
And if I search é show entities where é and e in their name.
Answer
That depends of the collation implemented in the field of the MySql table. By default it's "utf8_general_ci".
See: http://dev.mysql.com/doc/refman/5.0/en/charset-collation-implementations.html
"utf8_general_ci is an example: 'a', 'A', 'À', and 'á' each have different character codes but all have a weight of 0x0041 and compare as equal."
regards!
I have change the collation of the field directly in the MySQL table but the search doesn't work yet.
I think that the source code must be update for implement this functionnality.
Test with latin1_bin, i just test it and work fine, look (I am Spanish):
The collations with ci (case-insensitive) at end compare as equal uppercase, lowercase and accented characters.
Thanks orthagh, I test your patch and it works fine.
This is implement in the future version of GLPI ?
The solution don't work in last version of Firefox.
I've got this error message :
TypeError: str is undefined at line script.js:958:7
Any idea ?
This is not the place to discuss it. Please use IRC, gitter or the dev mailing list.
Thank you.
The solution works fine : https://gist.github.com/orthagh/54efb748c5ef29c1a112
When will it be implemented ? 9.1 ?
Thanks.
Not implemented yet in 9.1.2.
The solutions works fine.
Can you implement it in 9.1.3 ?
Thanks.
Hello,
The solution works fine but it's not implemented in 9.1.3.
Can you implement in the next version please ?
Thanks.
This feature still does not work in the new version 9.2...
It's been more than 2 years now...
Hi,
Thanks for your suggestion.
This feature is too specific to be implemented in GLPI core.
It must be done in a plugin.
Regards
Customer support service by UserEcho
Hi,
Thanks for your suggestion.
This feature is too specific to be implemented in GLPI core.
It must be done in a plugin.
Regards