[DB-SIG] date/time handling
mfrasca at zonnet.nl
Mon Aug 7 08:48:25 CEST 2006
On 2006-0806 14:01:27, Robert Brewer wrote:
> > but then also data *going* to the database must be
> > clearly typed.
> Yes. The value-adaptation layer must be aware of the target column types.
sorry if I skip the rest, but I feel this is a crucial point.
I think that the value adaptation layer should not be aware of the
target column types, it should, according to me, base every choice on
local information, that is: the type of the incoming data, be it *from*
the database (and the type information is present in most engines)
or *to* the database (then the type information should be agreed on,
that is what we are doing here). if the user sends a string, it will
not be translated and the user is responsible for it being a valid
string representation of the typed value to be stored in the column.
"S'il y a un Dieu, l'athéisme doit lui sembler une moindre injure
que la religion."
-- Edmond et Jules de Goncourt
More information about the DB-SIG