+6
Declined

Accented characters in entities search

Dev Apps 8 years ago updated by glpi 5 years ago 18

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

Answer
Declined

Hi,

Thanks for your suggestion.

This feature is too specific to be implemented in GLPI core.

It must be done in a plugin.

Regards

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.

Hello,

Do you implement it in 9.1?

Thanks in advance.

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.

Not yet in GLPI 9.1.4...

Don't work in GLPI 9.1.6.

Can you implement in the next version?

This feature still does not work in the new version 9.2...

It's been more than 2 years now...

News about the implementation?

Answer
Declined

Hi,

Thanks for your suggestion.

This feature is too specific to be implemented in GLPI core.

It must be done in a plugin.

Regards