Comments on Search to recognize

•peumus Forum Regular Usergroup: Customer Joined: Aug 09, 2004 Location: Chile Total Topics: 172 Total Comments: 462	•peumus #1 - Quote - Permalink Posted Sep 03, 2008 - 9:40 AM: Paul, When people search for a term they expect the results to be the same if they write the word with an accent or without it. For example: if we search for the word: "orgánico" we should also present the results that contains the word: "organico" . So the search for words with accented letters shall also return the same words without accented letters: Accented letters are: á : a é : e í : i ó : o ú : u ñ : n Would it be possible to implement this ?
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7868	•Paul #2 - Quote - Permalink Posted Sep 09, 2008 - 7:43 AM: Could duplicate all the search query parts with the letters replaced, probably doable in a few hours.
•peumus Forum Regular Usergroup: Customer Joined: Aug 09, 2004 Location: Chile Total Topics: 172 Total Comments: 462	•peumus #3 - Quote - Permalink Posted Sep 11, 2008 - 11:25 PM: Paul wrote: Could duplicate all the search query parts with the letters replaced I believe that this way we shall have lot of combinations. Is it another direct way using MySql ? Checking at phpmyadmin, if I search for member name Jórge // accented on the o, using its search feature, it shows the executed query as: SELECT * FROM `wsnlinks_members` WHERE `name` LIKE CONVERT( _utf8 'Jórge' USING latin1 ) COLLATE latin1_swedish_ci LIMIT 0 , 30 And it founds the name Jorge that's not accented. This would be a fine performance (and maybe would take only one hour instead of two
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7868	•Paul #4 - Quote - Permalink Posted Sep 14, 2008 - 4:57 AM: Possibly. But to test it I'd have to spend that time.
•peumus Forum Regular Usergroup: Customer Joined: Aug 09, 2004 Location: Chile Total Topics: 172 Total Comments: 462	•peumus #5 - Quote - Permalink Posted Sep 14, 2008 - 10:35 AM: Ok Paul, I did run out of money this month so I can pay you the following.
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7868	•Paul #6 - Quote - Permalink Posted Sep 15, 2008 - 3:12 AM: Was there supposed to be more text in that post?

Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.