search special characters

[math]

Hi,

I've made a search-script, it searches in a mysql-table and just displays the results...
The problem is that users probably will search with only the normal characters, but in the mysql-table, ë é è is used (when correct)... How can i search so that if the users search for "Daniel", the results should also show "Daniël"...

Is it possible? how?

Thanx alot in advance,
Math

 

[sleipnir214]

Since "e", "è", "é", "ê", and "ë" are all very different characters, you'll have to write code that associates "e" with all its accented variants.

Both PHP and MySQL support regular expressions. That's probably the way to do.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!