[OpenSER-Devel] oracle schema, VARCHAR fields NOT NULL

[Henning Westerholt]

On Wednesday 23 April 2008, Dan Pascu wrote:
> > [..]
> > This causes a problem for the db_oracle module. For Oracle are
> > VARCHAR[,2] NULL values and the empty string ('') equivalent (don't ask
> > me why). Thus most of the insert statement, e.g. in the control scripts
> > fails for string values, because oracle think that they want to insert
> > NULL into the column, and this is not allowed.
> >
> > Are this NOT NULL defines actually needed if an default value is
> > specified?
>
> I think they are, because I can connect to the database by other means and
> manually insert/modify an entry and set that to NULL. Then the software
> will get confused because it doesn't expect a NULL value in that column.
> [..]

Hello Dan,

this is a good point. Ok, i'll change the oracle xsl script later, the other 
database SQL schemes will be not affected.

Cheers,

Henning