Im also curious for the answer why. We got a similar issue. Seems like those values are cached somehow so clear cache all made the values visible that are in the database. Cck seems to turn 0 into null even for integers. We did not search to much further on it because clearing the cache solved the issue.
Hans www.koba.be
2010/1/3, VJ vijaiprao@gmail.com:
Hi, I have updated a field in a cck table (content_type_resource) using sql. The update executed successfully. However, upon accessing the node via a web browser, the updated values seem to get replaced by NULL. Anyone notice this behavior in Drupal 6 before?
-v