[OpenSER-Devel] missing datatype length in db schemes

Henning Westerholt henning.westerholt at 1und1.de
Fri Apr 11 10:16:47 CEST 2008


On Thursday 10 April 2008, Bogdan-Andrei Iancu wrote:
> Note that in mysql the len spec has a different meaning. It has nothing
> to do with the number of bytes the data has - this is predefined per
> type -, but it is a display spec (number of digits to be displayed) :).
>
>     http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
>
> Not sure how it is for postgres, but just want to be sure there is no
> confusion.

Hi Bogdan,

yes, i read also this docs, and IMHO this is confusing.. So the proposed 
change for mysql is then even a smaller thing. Most datatypes in the schemes 
are probably way big enough anyway. For postgres the size for 'INTEGER' is 
completly ommited anyway, perhaps its make sense to use this way also for the 
oracle module. This would mean that nothing needs to be changed.

Cheers,

Henning



More information about the Devel mailing list