Re^2: Inserting an empty string, not NULL, with $dbh->quote()

in reply to Re: Inserting an empty string, not NULL, with $dbh->quote()
in thread Inserting an empty string, not NULL, with $dbh->quote()

Additional hint: MySQL has some documented, but non-obvious "features". NULL handling is one of them.

Side node: Oracle also has the nasty habit of treating NULL and empty strings equally or converting one to the other -- not always, but always when you don't expect it.

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

Comment on Re^2: Inserting an empty string, not NULL, with $dbh->quote()

Replies are listed 'Best First'.
Re^3: Inserting an empty string, not NULL, with $dbh->quote() by morgon (Priest) on Jan 05, 2012 at 23:53 UTC
Oracle also has the nasty habit of treating NULL and empty strings equally or converting one to the other -- not always, but always when you don't expect it. With VARCHAR2 there is no "treating equally or converting". An empty VARCHAR2-string IS a NULL - always.	[reply]

In Section Seekers of Perl Wisdom