CODEWITHSUNDEEP
phpmysqlsearch
Romans Leonovs
Romans Leonovs

Reputation: 53

Mysql + PHP Search word without utf8

I get problem with mysql search LIKE For example in database table city i have record "Rīga"
How you see in database Word "Rīga" have "ī" not "i" letter.
Is it posibble to make in search even if i write with regular "i" letter?
Because this variant isnt working

SELECT * FROM `city` WHERE `title` LIKE '%Riga%'

Upvotes: 0

Views: 130

Answers (2)

CarlosCarucce
CarlosCarucce

Reputation: 3569

You should use the same connection encoding as your database before executing queries.

If you're using PDO, just set the connection encoding as:

$encoding = "utf8"; //replace this value with the character encoding you're using
$pdo = new PDO("mysql:host=host;dbname=my_db;charset=$encoding", $user, $pass);

If you're using MYSQLI, use mysqli_set_charset:

$encoding = "utf8"; //Use your encode here
$con = mysqli_connect("host",$user,$pass,"my_db");
mysqli_set_charset($con, $encoding);

Edit~

You may need also to use Accent insensitive collation (UTF8_GENERAL_CI) in your database. I believe your problem is already solved in the post MySQL charsets and collations: accent insensitive doesn't work

Upvotes: 0

Sylter
Sylter

Reputation: 1623

It's called Accent insensitive search: you can find a good answer right here! Accent insensitive search query in MySQL

Other answers:

Upvotes: 2

Related Questions