argrafic Posted January 25, 2008 Share Posted January 25, 2008 Hello all. In a site i'm developing in spanish I have a simple search engine, but I have a little problem. I want the search engine to find words even if you write them with or without accent. For example atún (tuna) has an accent, and right now it will only show results if i write atún, if I write atun it tells me there are no results. My SQL statement is the following: SELECT * FROM r_glosario WHERE titulo LIKE '%variable%%' ORDER BY titulo ASC How can I make it that no matter if I write atún or atun I get the same results? Thanks! Quote Link to comment Share on other sites More sharing options...
revraz Posted January 25, 2008 Share Posted January 25, 2008 Interesting problem, since they are in fact two different characters. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.