I’ve just compiled a database of 1 million place names. I’m going to use it in an auto-complete widget to look up cities. A lot of these places have accents… I want to be able to find records when a user types the name without an accent.
Is there any way to make search query accent insensitive?
I’m trying to save French accents in my database, but they aren’t saved like they should in the DB.
For example, a “é” is saved as “é”.
I’ve tried to set my files to “Unicode (utf-8)”, the fields in the DB are “utf8_general_ci” as well as the DB itself.
When I look at my data posted through AJAX with Firebug, I see the accent passed as “é”, so it’s correct.
I’m running the following select statements on MySQL 5.0.88 with utf8 charset and utf8_unicode_ci collation:
I found that i can achieve this point by using the BINARY Keyword (see this sqlFiddle). What is the difference between collate and binary?
What I want to do is to remove all accents and umlauts from a string, turning “lärm” into “larm” or “andré” into “andre”. What I tried to do was to utf8_decode the string and then use strtr on it, but since my source file is saved as UTF-8 file, I can’t enter the ISO-8859-15 characters for all umlauts – the editor inserts the UTF-8 characters.
Is it possible? This is my input string:
I am making a swedish website, and swedish letters are å, ä, and ö.
I rewrite URLs to include the title of user generated travelblogs.
I am using Node.js and Express.js 3.x.
