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
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
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