[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://www.mysql.com/doc/en/String_comparison_functions.html
http://www.mysql.com/doc/en/String_functions.html
You probably want lpad, rpad, or space
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
