convert ü to u

Question

hi all

I'm using a database that contains contacts (fields like name, address, ...). If i'm using in my database a city that contains special chars (like ü) or html codes (like ü), then how can i convert them to u, so when i search for a city that contains that a special char should be shown in the result...

the database is MyISAM and Collation is latin1_swedish_ci (by default)

Answer 1

1. Your database shouldn't contain any HTML codes but symbols itself.
2. With proper collation set, you will find both ü and u with your query

Edit: using collations example

Answer 2

you probably want to look at this article for other ideas and tools for how to solve your search problem. Normalizing your database search to latin-1 characters isn't the right solution.

http://www.alistapart.com/articles/accent-folding-for-auto-complete/