How to best handle zero length String ("") inserts between different DBMSes - some complain it is null - Ralf Hauser - com.mysql.lists.java

5 messages in com.mysql.lists.javaHow to best handle zero length String...

From	Sent On	Attachments
Ralf Hauser	26 Mar 2005 02:07
Ralf Hauser	26 Mar 2005 02:56
lee	26 Mar 2005 11:33
Mark Matthews	27 Mar 2005 07:10
Ralf Hauser	29 Mar 2005 00:57

Subject:	How to best handle zero length String ("") inserts between different DBMSes - some complain it is null
From:	Ralf Hauser (ralf...@gmx.ch)
Date:	03/26/2005 02:07:00 AM
List:	com.mysql.lists.java

Hi,

Just ported an application that worked nicely under mysql also to oracle and found an interesting difference: - mysql considers "" as a non-null string - oracle complains that an attempt to insert a null string was made with "".

Is one of the two correct or is that just something that has to be coped with on the application level since that standards do not define this?

Or could jakarta-commons dbcp act as a portability ensuring layer? See http://issues.apache.org/bugzilla/show_bug.cgi?id=34187 for a detailed description of this idea and a test case to reproduce this difference.

Any thoughts would be highly appreciated

Ralf

Securely and spam-free via: https://www.privasphere.com/e.do?email=hau...@acm.org