Searching with special (foreign) charact

[Anon]

I'm making a search engine in PHP-MySQL, but I have troubles with special characters. Example: In the database exists a row with name='José'.

If I write in the code: select * from table where name like '%Jose%'; nothing appears. And viceversa.

But if I write: select * from table where name like '%José%'; appear the row.

How do I to appear the row 'José' when the user make a search with 'Jose' and 'José'?

Please, I'm sorry for my English.

[vsego]

If noone provieds better solution, try with additional field in the table. I.e. name='José' and crippled_name='Jose'. (these 2 would be equal for words with no special chars, i.e. name='Maria' and crippled_name='Maria')

When user asks for something that has ANY of the special chars, search by name. If no special chars are present, search by crippled_name.

[Anon]

But that method is not optimum (last way). My server is a 'pote'.

Exists another way?