01-24-2016, 03:59 PM
There is a simple solution to your accents problem. All you have to do is add an additional simple variable to your database. Basically you would have two variables for each game title; one for the name displayed in the icon, and one hidden one for searches.
For example, if someone created a game section for a game called "Pokèmon: Brown Version", the database would store two versions of the name:
[[Visible Name]]: Pokèmon: Brown Version
[[Hidden Name]]: Pokemon: Brown Version
It would be extremely simple to set it up to do this automatically.
Then, when someone performs a search for a word that contains an accent, it just has to quickly strip the accent from the search request and perform the search in the Hidden Name table rather than the Visible one.
And since most games don't have accents attached to them, creating the second variable to your database table should be a piece of cake, since you literally just need to tell it to copy the existing name column, and then go back and edit the few games that need the accents.
For example, if someone created a game section for a game called "Pokèmon: Brown Version", the database would store two versions of the name:
[[Visible Name]]: Pokèmon: Brown Version
[[Hidden Name]]: Pokemon: Brown Version
It would be extremely simple to set it up to do this automatically.
Then, when someone performs a search for a word that contains an accent, it just has to quickly strip the accent from the search request and perform the search in the Hidden Name table rather than the Visible one.
And since most games don't have accents attached to them, creating the second variable to your database table should be a piece of cake, since you literally just need to tell it to copy the existing name column, and then go back and edit the few games that need the accents.