ansaurus

Question

php, mysql: compare strings - accent sensitive and case insensitive

Answer 1

A:

You can try to echo the sql being executed and check if the accents are there.

My guess they are not...

[EDIT]

Can you try this:

php.

<html>
<head>
</head>

<body>
<form action="" method="get">
<input name="name" type="text"/>
<input type="submit" value="go"/>
</form>

<?php
if (!empty($_GET['name'])) {
    $mysqli = new mysqli('localhost', 'root', '', 'test');
    $mysqli->set_charset('latin1');

    $_GET['name'] = utf8_encode($_GET['name']);

    if ($result = $mysqli->query('select * from dummy where LOWER(name) LIKE _utf8 \'%' . $_GET['name'] . '%\' COLLATE utf8_bin')) {
        while ($obj = $result->fetch_object()) { 
            var_dump($obj->name); 
        }
    }
    $mysqli->close();
}
?>
</body>
</html>

mysql: (doesn't matter)

CREATE TABLE `dummy` (
  `id` int(11) NOT NULL,
  `name` varchar(45) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin5$$

This one works for me...

sheeks06 2010-09-21 07:38:02

i tried echoing it and the accents are there. the echoed statement was also the query i used to run in phpMyAdmin.

user398651 2010-09-21 07:40:52

check my edited answer

sheeks06 2010-09-21 08:15:51

thanks! but i can't set my table's collation to utf8_bin as it has to be case and accent insensitive. i only have one instance in which i have to make an accent sensitive comparison..

user398651 2010-09-21 08:25:21

final answer :)

sheeks06 2010-09-21 09:16:49

try utf8_encode. works perfectly

sheeks06 2010-09-21 09:18:35

ok, thanks! will try first thing in the morning..

user398651 2010-09-21 12:09:09

you're right! adding utf8_encode made it work. thanks!!

user398651 2010-09-22 00:05:31

ansaurus

tags:

views:

answers:

php, mysql: compare strings - accent sensitive and case insensitive

related questions