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