match against problem

My queries in MySQL
1. select * from table where match (title) against ('prici')
2. select * from table where match (title) against ('prići')
3. select * from table where match (title) against ('priči')
all return the same result. Relevant table field contain
word 'prići', so I have expected that only second query
return non-empty result. Does anyone know cause of this problem?

Re: match against problem

Runner schrieb:
> My queries in MySQL
> 1. select * from table where match (title) against ('prici')
> 2. select * from table where match (title) against ('prići')
> 3. select * from table where match (title) against ('priči')
> all return the same result. Relevant table field contain word 'prići',
> so I have expected that only second query return non-empty result. Does
> anyone know cause of this problem?
Hi

look here in german a few words about character sets and collations :
http://blog.koehntopp.de/archives/1424-MySQL-Zeichensatz-Gru ndlagen.html
you have a wrong collation you can use utf-8 but this needs more
storage. (http://dev.mysql.com/doc/refman/5.0/en/charset-server.html
helps you too)

greets
Thomas Butz