Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Comment on

( #3333=superdoc: print w/replies, xml ) Need Help??

"unknown" values are represented - in our case - by a value that falls outside the legal range. e.g. a for numeric values defined to be 0 or greater, we use -1 to be the "undefined" value and -2 to be the "known to be wrong or invalid" value. For strings that decision is taken on each case, some already have a value for "known to be unknown": . (not our choice, it is a law in that database) others might be a single space.

varchar2 is Oracle-only, yet another reason to loathe Oracle. Indeed we use varchar2 instead of varchar, but they suck nevertheless.

I just don't understand how you can say that an empty string equals to NULL. That is only true in the rotten Oracle world.

FWIW I use a lot of database types (Oracle, Unify, MySQL, PostgreSQL, MariaDB, SQLite, CSV, TSV, MonetDB) and NONE is perfect. Oracle is not the only database with drawbacks.

The is more btw, how to represent (in a database)

  • Known, valid ("normal" state in databases)
  • Known to be unknown (I checked it, but the value cannot be set)
  • Known to be absent/unavailable
  • Unknown ("NULL" in databases)
  • Known to be illegal (cannot use the illegal value, like date of birth 23770245)

Enjoy, Have FUN! H.Merijn

In reply to Re^3: "undef" is not NULL and what to do about it by Tux
in thread "undef" is not NULL and what to do about it by Ovid

Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":

  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?

    What's my password?
    Create A New User
    [Corion]: "zero monetary cost", because of course, it's gratis only if your time has no value :)
    [marto]: I used to keep up to date with my android ROMs, updating to the nightly every other day
    [marto]: in my experience the jump in major releases has been painless, and performed better
    [marto]: Corion if your device has an official Oreo ROM I'd do a nandroid backup and give it a shot

    How do I use this? | Other CB clients
    Other Users?
    Others scrutinizing the Monastery: (7)
    As of 2017-12-14 10:43 GMT
    Find Nodes?
      Voting Booth?
      What programming language do you hate the most?

      Results (389 votes). Check out past polls.