Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re^2: "undef" is not NULL and what to do about it

by nikosv (Hermit)
on Feb 20, 2013 at 20:07 UTC ( #1019838=note: print w/ replies, xml ) Need Help??


in reply to Re: "undef" is not NULL and what to do about it
in thread "undef" is not NULL and what to do about it

++ for the link!

This is one of the reasons why we - in ALLL our database types - disallow NULL values. All fields should have (default) values

can't avoid the nulls produced by the outer joins though,i.e a left one

If I insert an empty string into a varchar field in Oracle, it helpfully inserts a NULL instead

I am not familiar with Oracle;how does it behave when when you put a not null constraint on the column?

catering for nulls is such an important issue that for example C# introduced Nullable Types into the core language


Comment on Re^2: "undef" is not NULL and what to do about it

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1019838]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (5)
As of 2015-07-28 05:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (252 votes), past polls