Re: Pro*C: Loss of Decimal Places INSERTing From "double" Host Var into NUMBER(16,6) Column

On May 21, 9:41 am, "Fleetie" <flee..._at_nospam.com> wrote:
> > Use timestamp datatype.
> > Jim
>
> Forgetting for now what the data is representing - pretend it's just a
> number with 6 decimal places right of the point - I would still like to
> know why my data is getting truncated.
>
> I did not design this database I'm working on; it's >10 years old, and
> I can't change it.
>
> So anyone know why the truncation?
>
> Thanks in advance,
>
> Martin

Not without seeing the source code. You do realise that there is the BINARY_DOUBLE datatype available?

David Fitzjarrell Received on Wed May 21 2008 - 12:35:24 CDT