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/[email protected]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
