Re: inserting white spaces

2003-12-08 Thread Andrey Subbotin
Hello Lemasson. Monday, December 8, 2003, 8:16:18 PM, you wrote: LS> I have a table witch has a column of type VARCHAR(10) LS> BINARY. When I tried to insert white spaces in it (insert into LS> mytable (mycolumn) values('')), an empty String is stored. Why? This is a documented behavior:

RE: inserting white spaces

2003-12-08 Thread Jay Blanchard
[snip] 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? [/snip] Because (' ') is an empty string see http://www.mysql.com/doc/en/String_syntax.html http:

inserting white spaces

2003-12-08 Thread Lemasson Sylvain
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 M