[OpenSER-Devel] missing datatype length in db schemes

[Bogdan-Andrei Iancu]

Hi Henning,

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.

Regards,
Bogdan

Henning Westerholt wrote:
> Hi,
>
> some tables missing a length specification for some of their INTEGER columns. 
> This causes problems for Iouri and me during the integration of db_oracle 
> into the XSL/XML db framework. We choose to use the 'NUMBER' type for storage 
> of 'INTEGER' values, but this needs a size specification. Oracle has also 
> an 'INTEGER' type, but for this its not valid to specify a size, as most 
> colums do.
>
> The tables and columns in question with the proposed length:
>
> 1. version
> table_version - 11
>
> 2. silo
> inc_time - 11
> exp_time - 11
> snd_time - 11
>
> 3. gw
> grp_id - 11
> flags  - 11
>
> Sounds this reasonable? Any other suggestions?
>
> Cheers,
>
> Henning
>
> _______________________________________________
> Devel mailing list
> Devel at lists.openser.org
> http://lists.openser.org/cgi-bin/mailman/listinfo/devel
>
>