[EMAIL PROTECTED] wrote:
> This is what I thought: I have three entries:
> 12. afan, pasalic, afan_at_afan_dot_net, 2003-12-18
> 13. Afan, Pasalic, Pasalic_at_yaoo_dot_com, 2001-01-01
> 14. AFAN, PASALIC, ammtar_at_gamil_dot_com, 2003-12-18
>
> If I search for *afan* only entry no. 12 will be shown
Sorry. :)
This is what I thought: I have three entries:
12. afan, pasalic, afan_at_afan_dot_net, 2003-12-18
13. Afan, Pasalic, Pasalic_at_yaoo_dot_com, 2001-01-01
14. AFAN, PASALIC, ammtar_at_gamil_dot_com, 2003-12-18
If I search for *afan* only entry no. 12 will be shown.
If I search for *Afan*
It's not clear to me whether you want the search to be case sensitive or not,
but you need to make sure that the right collation is used. Case sensitive
collations end in "_cs" and case insensitive collations end in "_ci".
Read about collations in chapter 10 of the manual:
http://www.mysql.se/d
on 11/18/05 2:27 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
> but I'm getting case insensitive search?!? it's not the same I enter
> afan or Afan or AFAN!??
>
> Any ideas?
Set the field type to binary, or use your php to compare the result to the
entered result.
--
--
[EMAIL PROTECTED] wrote:
but I'm getting case insensitive search?!? it's not the same I enter
afan or Afan or AFAN!??
Your two statements contradict each other. Either you are getting case
insensitive search, meaning that it *is* the same if you enter afan,
Afan or AFAN, or you're getting cas
