Searching with accented words
Hi, before of anything i send all you my best regards and apologize for my english as long as i'm still learning it!!...
I have this issue and i don´t know what's happening. My database consist in one table of books with the title and the author of the book, both fields are available for search. I access the database through a web interface developed with php. The books' titles are mostly in spanish language. All my database, all my tables and all my varchar, char and so on columns are utf-8 as character set and utf-general-ci as collation. When a book's title contains an accented word, for instance, "Psicología" (spanish for Psychology), in the database is stored a special character for the "í" word, what i think, it`s correct for the character set and collation. When a retrieve this field and show in my webpage, everything it's fine, it shift the special character to the original and show "Psicología". Everything's as i expected that my webpage behaves. When the problems begins?, well, my webpage provides a search functionality, and when i type in the search box "Psicologia" it doesn`t find the bool with the title "Psicología". In other words, if i accented a vowel, i cannot find the book with if i try the search with the no-accented word. I believe, that using utf8 i avoid this problem because, the collation manages this issue. Am i wrong?. Should i use another collation or character set to address this problem...?
Thanks in advance... Regards...