|Storing empty strings in an oracle database [message #538322]
||Mon, 07 June 2010 11:22
Registered: June 2010
I've a question how to handle empty strings and NULL for "String" columns in a oracle database.
I know Oracle treats an empty string as NULL and therefore a column definition with nullable=false will cause a rollback on inserts with an empty string as value.
The only workaround I've found is to use a "special character" to mark an empty string.
I want to support more than one database system, not only oracle.
I use EclipseLink 1.1.3
Are there any other solutions?
Powered by FUDForum
. Page generated in 0.06073 seconds