Case sensitive search and login
 

Hi, my forum is case sensitive.
If i search for something that was written as : Mama, i have to search for Mama, if i search for mama it is not showing results...

same: users need to login as they was registered, i mean, if i registered as Monk, i cant login as monk, i have to login as Monk and write Monk in login or it will show that no user ;]

how to disable case sensitive in my forum? is it server's problem or what?:)
help...

Check the character encoding on the table, what is it set to?

On which table?
All tables ar Myisam and utf bin... all works fine , but those case sensitive is killing me:)

utf_bin means, BINARY, which means case sensitive. You need to change it to utf8_ci

Thank you very much for fast and pro answer.
My forum www.Pecetowiec.pl is working now as hell good:)

Yes. It was utf8 bin problem. I changed all tables into utf8_general_ci but it didnt helped.
I had to make backup of database, change coding in database (i opened it and changed strings in base from utf8_bin into utf8_general_ci), saved database and import via phpadmin back... Then i had to merge one user wuth other (his name was Gege and secons user was gege - small letter on begin), and i rebuilded search in maintence. Works fine now.

Thanks .