accent sensitivity in fulltext search

[Salam Baker Shanawa]

Hi, 

How can I have accent sensitive, case insensitive fulltext query? 

version: 5.0.45 
The database, tables, connection, data etc. are all utf8. 

select name from people where match(name) against ('königsberger' in
boolean mode); 

shouldn't return konigsberger.

Any idea, collation? 

Regards 
Salam



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: accent sensitivity in fulltext search

[Santino]

Hi,
try to set the collation to utf8_unicode_ci.
I have had the inverse problem and I solved with utf8_general_ci.

Santino

At 19:33 +0100 16-02-2009, Salam Baker Shanawa wrote:

Hi,

How can I have accent sensitive, case insensitive fulltext query?

version: 5.0.45
The database, tables, connection, data etc. are all utf8.

select name from people where match(name) against ('königsberger' in
boolean mode);

shouldn't return konigsberger.

Any idea, collation?

Regards
Salam



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/mysql?unsub=santino.cusim...@gmail.com



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: accent sensitivity in fulltext search

[Salam Baker Shanawa]

Thanks Santino, but unfortunately didn't help .

I tried utf8_bin, just for checking, same results¸
Not even the case sensitivity is respected.

The following queries return the same results:

select name from people where match(name) against ('königsberger' in
boolean mode);

select name from people where match(name) against ('koNigsberger' in
boolean mode);

Königsberger 
konigsberger

Could it be a version dependent problem?

Regards
Salam


On Mon, 2009-02-16 at 20:26 +0100, Santino wrote:
 Hi,
 try to set the collation to utf8_unicode_ci.
 I have had the inverse problem and I solved with utf8_general_ci.
 
 Santino
 
 At 19:33 +0100 16-02-2009, Salam Baker Shanawa wrote:
 Hi,
 
 How can I have accent sensitive, case insensitive fulltext query?
 
 version: 5.0.45
 The database, tables, connection, data etc. are all utf8.
 
 select name from people where match(name) against ('königsberger' in
 boolean mode);
 
 shouldn't return konigsberger.
 
 Any idea, collation?
 
 Regards
 Salam
 
 
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe: 
 http://lists.mysql.com/mysql?unsub=santino.cusim...@gmail.com
 
 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org