Accent-insensitive substring matching

bubu

New Member
I have a search functionality that obtains data from an InnoDB table (\[code\]utf8_spanish_ci\[/code\] collation) and displays it in an HTML document (\[code\]UTF-8\[/code\] charset). The user types a substring and obtains a list of matches where the first substring occurrence is highlighted, e.g.:\[code\]Matches for "AL":
 
Back
Top