Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. andyclap

    null string problem

    I'll have to check out that book ;) Anyway, if we go back to the root question of this topic (working with Oracle strings in VB), the answer really is that: Yes, this is the defined behaviour of Oracle, and you have to work with it at an application level by treating blank string as a special...
  2. andyclap

    null string problem

    SantaMufasa - in the words of the Lord Codd almighty ... ;) Commandment 3: Systematic Treatment of Null Values A field should be allowed to remain empty. This involves the support of a null value, which is distinct from an empty string or a number with a value of zero. Interestingly I have...
  3. andyclap

    null string problem

    Yes, absolutely agreed - I'm not debating this at all. I'm pointing out that from a programmer's perspective Oracle's behaviour is incorrect.
  4. andyclap

    null string problem

    Aha, but surely that's the whole point of this little discussion... ;) I like the concept of NULL representing 0 bits of information; however '' does not represent 0 bits of information. While '' may be a zero length string, it is a string constant, and therefore there is some information here...
  5. andyclap

    null string problem

    rogolia - interesting... do you mean the actual low-level content of the field here - in which case how would you write transparent access methods for this, and would the db remain performant? Or are you talking about using chr(0) as a string value? Chr(0) is of course, not null.
  6. andyclap

    null string problem

    >or just replace all checks for the empty string with is null or is not null? >select * from designer where username is null >would replace >select * from designer where username = ''. Seems easy enough Yep, that's about it. But of course, if you're building the SQL in code, using a...
  7. andyclap

    null string problem

    >If "database theory 101" calls something else NULL, then what does "database theory 101" call the absence of value? you're probably misinterpret my message ... "Database theory 101" absolutely calls NULL the absence of value. It has no value therefore nothing...
  8. andyclap

    null string problem

    incidentally > blank means having 1 or more spaces in it You've been working with oracle too long ;-) 1 or more spaces in a string means it is a string of one or more spaces.
  9. andyclap

    null string problem

    It's one of the fundamental flaws of Oracle. A blank string is treated as null. This is just plain wrong: Somebody who designed the DB engine didn't pass their database theory 101. You have to check for blank strings using is null, this means that your varchar fields no longer have a logical...

Part and Inventory Search

Back
Top