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 '' ? 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. 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. Link to comment https://forums.phpfreaks.com/topic/72421-length-of-null/#findComment-370902 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.