Search engine with accents

[kickoutbettman]

Hello all,

 

I created a little simple search engine and it works great for what I need.

My only problem, is the data in MySql DB might contain some accents such has : é à è ê

And some people will not put the accent and others will.

 

Is there any way to let my search engine returns both results ?

 

Thank you

 

[kickoutbettman]

Am I at the right place.

Should this topic be posted in PHP forum ? ???

[gassaz]

Use LIKE... example:

 

select * from base where name like 'something'

 

If 'something' exist into the table with accent or with out accent, the select will show the records.

[kickoutbettman]

You are right, it does work with MySql.

It returns the good result.

 

The problem is that I use PHP and a HTML form to grab the input from the user then assign it to $filter.

 

$filter = $_GET['textfield'];

SELECT * FROM city WHERE cityName LIKE '%$filter%'

***city example = Montréal ***

 

So when I do that and type "Montreal" it returns nothing. But if I type "Montréal" it returns Montréal.

The collation for my table = utf8_general_ci (so it should manage the accents correctly).

 

Anybody knows whats happening ?

 

Thanks

[fenway]

You should be able to CONVERT to an accent insensitive collation, like latin1.