Hi
What happened with this problem, are you working on it? As Peter said there
has to be a way that every possible value is allowed. But it's even worse
with strings because you can't save an empty string in the database because
it's convertet into a NULL value.
Rafael Bischof
-----Ursprüngliche Nachricht-----
Von:
es-devel-bounces@...
[mailto:
es-devel-bounces@...] Im Auftrag von Peter Wyss
Gesendet: Freitag, 6. Juli 2007 15:43
An:
manus@...;
es-devel@...
Betreff: AW: [Es-devel] WG: EiffelStore DB_STORE writes NULL instead of
emptystring
Hi,
yes, that helps in my case, but I think there should be a solution that
works with every value.
Peter
-----Ursprüngliche Nachricht-----
Von: Emmanuel Stapf [ES] [mailto:
manus@...]
Gesendet: Freitag, 6. Juli 2007 15:12
An: 'Peter Wyss';
es-devel@...
Betreff: RE: [Es-devel] WG: EiffelStore DB_STORE writes NULL instead of
empty string
You can define the NUMERIC_NULL_VALUE to be {INTEGER_32}.min_value, that
might be enough for integers if you do not store {INTEGER_32}.min_value.
Regards,
Manu
> -----Original Message-----
> From:
es-devel-bounces@...
> [mailto:
es-devel-bounces@...] On Behalf Of Peter Wyss
> Sent: Friday, July 06, 2007 2:02 AM
> To:
es-devel@...
> Subject: AW: [Es-devel] WG: EiffelStore DB_STORE writes NULL instead
> of empty string
>
> Hi,
>
> is there a feature to deactivate this NULL value completely?
> If someone has an integer field (NOT NULL) there is no safe value for
> numeric_null.
>
> Peter
>
> -----Ursprüngliche Nachricht-----
> Von: Emmanuel Stapf [ES] [mailto:
manus@...]
> Gesendet: Donnerstag, 5. Juli 2007 20:39
> An: 'Peter Wyss';
es-devel@...
> Betreff: RE: [Es-devel] WG: EiffelStore DB_STORE writes NULL instead
> of empty string
>
> In the class NUMERIC_NULL_VALUE we define what the default value
> should be to store a NULL value instead of the actual value. This
> should work for INTEGER, REAL and DOUBLE.
> Unfortunately we do not have anything for STRING but I'm not sure why
> an empty string would be store as a NULL. I'll have to check further.
>
> Manu
>
> > The same problem occurs with integer value 0.
> >
> > -----Ursprüngliche Nachricht-----
> > Von: Peter Wyss [mailto:
wyssp@...]
> > Gesendet: Dienstag, 26. Juni 2007 14:26
> > An: '
es-devel@...'
> > Betreff: EiffelStore DB_STORE writes NULL instead of empty string
> >
> > Hi,
> >
> > when writing an empty string ("", not Void) to a MySQL
> database using
> > DB_STORE, EiffelStore writes NULL into the database field
> instead of
> > the empty string.
> > If the field is defined with "NOT NULL", this leads to a database
> > error.
> >
> > Regards
> > Peter
> >
> > _______________________________________________
> > Es-devel mailing list
> >
Es-devel@...
> >
http://rock.inf.ethz.ch/cgi-bin/mailman/listinfo/es-devel> >
>
> _______________________________________________
> Es-devel mailing list
>
Es-devel@...
>
http://rock.inf.ethz.ch/cgi-bin/mailman/listinfo/es-devel>
_______________________________________________
Es-devel mailing list
Es-devel@...
http://rock.inf.ethz.ch/cgi-bin/mailman/listinfo/es-devel_______________________________________________
Es-devel mailing list
Es-devel@...
http://rock.inf.ethz.ch/cgi-bin/mailman/listinfo/es-devel
