inserting white spaces

Hi, I have a table witch has a column of type VARCHAR(10) BINARY. When I tried to insert white spaces in it (insert into mytable (mycolumn) values('')), an empty String is stored. Why? Lemasson Sylvain Ingénieur développeur [EMAIL PROTECTED] tel: 01.48.63.27.27 MAK-SYSTEM SERVICES Groupe

primary key type is BLOB

I try to add a primary key on a BLOB column and I have got an error (ERROR 1170: BLOB column 'value5' used in key specification without a key length). May be the answer is in the documentation but I did not find it. So how could I make my BLOB column a primary key? Lemasson Sylvain Ingénieur

Expressions in the select query are case insensitive

is: [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe basedir=d:/mysql datadir=D:/mysql/data default-character-set=utf8 collation=utf8_bin lower_case_table_names=0 Can something be done so that mysql be case sensitive ? Lemasson Sylvain Ingénieur développeur [EMAIL PROTECTED] tel: 01.48.63.27.27 MAK-SYSTEM

About maxdb

event log. Thank you. Lemasson Sylvain Ingénieur développeur [EMAIL PROTECTED] tel: 01.48.63.27.27 MAK-SYSTEM SERVICES Groupe MAK-SYSTEM Paris Nord 2 - 13, rue de la Perdrix BP 50035-95946 Roissy CDG Cédex FRANCE