Re: [Bodington-developers] Gotcha with facility/session split

[Jon M. <jo...@te...>]

I don't think there's a problem with leaving the schema as it is. 
However, some database products (oracle?) think "" == null which would 
be a problem. I.e. trying to put "" into the field will through a "nulls 
not allowed" error.

Could we put "unknown" or "unset" in instead of null?

Adam Marshall wrote:

>RDBMS-specific scripts - there's already a precedent for this isn't there?
>
>Ada.
>
>  
>