Hello, I have two arrays, both are from UTF-8 collated DB and their contents are keywords in any language. I want to get the intersection of keywords between the two tables, but I want the results to be like as MySQL queries match, so that Accents, Diacriticals and Special Language Characters in some languages, are ignored. For example, in a mysql query, if you do select from the table X records that contains keyword "apple" with a WHERE keyword = 'äpplê' Now, I do: $result = array_intersect($arrayX, $arrayY); but result will not contain 'apple'. How can we make the function do string comparisons this way (like collated in DBs) ???? Thanks for your time !!!
Have you played around with the soundex command? You can use it either in MySql when you get your data or in PHP when processing the data. If so, how successful was it?
not sure why or how soundex can help here, I finally ended that the best solution, is to make a function that removes all accents... anyone can help with this to work for all languages ???