tommo74 Posted October 9, 2007 Share Posted October 9, 2007 If I do a select length(name) as length from User and get : length | --------+ | 0 | (2 rows) Does that mean that one of the rows is null and the other one has a value of '' ? Quote Link to comment https://forums.phpfreaks.com/topic/72421-length-of-null/ Share on other sites More sharing options...
fenway Posted October 9, 2007 Share Posted October 9, 2007 Interesting... LENGTH(null) = NULL, not sure why you're getting blank. Quote Link to comment https://forums.phpfreaks.com/topic/72421-length-of-null/#findComment-365292 Share on other sites More sharing options...
lemke411 Posted October 16, 2007 Share Posted October 16, 2007 What I have noticed that MySQL and PHP that blank is null so there would be no result for the length. I don't even think that a 0 will be displayed for the length. Quote Link to comment https://forums.phpfreaks.com/topic/72421-length-of-null/#findComment-370902 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.