Linked Questions

Possible Duplicate: How to conduct an Accent Sensitive search in MySql I have a MySQL database which consists of list of words which contain both French and English Letters in a table. Ex : Datas ...

My query is: SELECT * FROM enwiki.page where title_text = 'drug'; One of the results I got has the tilte_text = 'Drûg'. How can I prevent that?

I'm running: MySQL Software version: 5.5.25 - Source distribution I have a table like this: Region | City ----------------- quebec | montreal _________________ quebec | montréal The cities are ...

I setup an InnoDB in mysql 5.7.26. The characterset is utf8mb4, but now i found out some wrong behaviour when filtering by umlauts. Setup: mysql> SHOW VARIABLES WHERE Variable_name RLIKE '^(...

I am using a pdo connection to my mysql database (utf8_general_ci) and the connection sets charset to charset=utf8: public function connect() { $dsn = 'mysql:host=' . $this->host . ';dbname=' . ...

I have a column which has values like 'fur' and 'für'. Now if I write the query select * from table where text = 'fur'; it gives me both 'fur' and 'für' and I want it to only return 'fur'. Which ...

The Problem: I am trying to implement a search algorithm that shows the results even when dotted chars are provided. In other words: SELECT 'über' = 'uber' or SELECT 'mas' = 'maş' these results will ...

I have the following select statement where I'm trying to search for a players first and last name that may contain accents in it. $sql = " SELECT * FROM player WHERE player.player_first ...

I am running a MySQL 5.6.26 on Windows 2012R2, in mysql.ini everything is configured to use UTF-8 Unicode (utf8). [mysqld] collation-server = utf8_unicode_ci init-connect='SET NAMES utf8' character-...

i need to perform a name search in the database based on a set of keywords. the result should be accent sensitive and case insensitive. following the solution i found here plus few modifications to ...

I didn't find anything good on that topic. Im currently implementing simple search function with will use LIKE to find requested records. But I wan't to make "accents-free" search. For example: ...

I'am trying to SELECT a cloumn in the table which contains only vowels. It works fine till I try to select entries with german umlauts (special chars like ä,ö,ü), then the query makes no difference ...

I have a database which I manage with phpMyAdmin. I have a table to save the verb tense and the verb. It looks like it follows: Column | Type | Collation | Attributes | Null | Default ...

I have some MySQL table with column 'title' which type is varchar(255), character set is utf8mb4 and collation is utf8mb4_general_ci. Lets say I have few records with title and those titles contain (...

select count(answer1) as total, questionsResults.answer1 from questionsResults WHERE correct=1 GROUP by answer1 My problem is that this groups lowercases and uppercases and even removes ...