Another Collation / Character Sets Problem

[Martin Hristov]

Hello,
I'm having trouble with my search engine.
It works perfectly with latin characters,
but when I write in Bulgarian (I'm from Bulgaria)
mysql tells me :
Illegal mix of collations (cp1251_bulgarian_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'like'

my database and the table are set to cp1251_bulgarian_ci, and I have managed to input Bulgarian characters in them via phpmyadmin.

I think I somehow have to set the collation or character set of the query i'm sending during the search. But how do i do that ?

Thanks a lot, and please ... excuse me if my english isn't good.