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

Reply via email to