Re: Expressions in the select query are case insensitive

2003-11-28 Thread Mikael Fridh
Sorry about the double posts... But I forgot something... On Friday 28 November 2003 14.51, Lemasson Sylvain wrote: > Can something be done so that mysql be case sensitive ? If you only need case-sentivitity on selects read this: http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html " The B

Re: Expressions in the select query are case insensitive

2003-11-28 Thread Mikael Fridh
On Friday 28 November 2003 14.51, Lemasson Sylvain wrote: > Hello, Hi > The first think is that I cannot add a primary constraint on test because > Mysql do not make the difference between 'bla' and 'BLA'. It is case > insensitive. I have the same problem when I do: select * from test where > valu