Expressions in the select query are case insensitive

2003-11-28 Thread Lemasson Sylvain
Hello, I have a simple table test like create table test (value varchar(10)); in witch I have insert two lines: insert into test values('bla'); insert into test values('BLA'); The first think is that I cannot add a primary constraint on test because

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

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