Re: Number to Character Datatype Translation
Dirk Niemeier wrote:
>
> > This seems to work most of the time. However, if I insert something like
> > 0.0000000000000000000000000000000000123456789 into the decimal(32)
> > column, the varchar(35) column receiving the converted value gets
> > 0.0000000000000000.
> >
> > Selecting from the decimal(32) column (using dbaccess) yieds a value of
> > 1.23456789e-35. Why don't I get this value when converting to
> > varchar(35)? Is there any way to obtain this value during the conversion
> > from decimal(32) to varchar(35), or any way to get the decimal expansion
> > of the value from a varchar(35) conversion?
> >
> > Thanks,
> > G.Carter
> > mailto:greg.carter@homemail.com
> > mailto:greg.carter@workmail.com
> > http://www.webaccess.net/~greg.carter
Hy Greg,
you need a char with a size of 37 Bytes. Remember: 1.23456789e-35 means
1 leading zero, decimal point, 35 digits.
If it doesn't work with varchar try char (37).
Greetings, Volker
--
Volker Fraenkle E-Mail: VFraenkle@cs-controlling.de
CS Controlling Phone: +49 7144 8144-0
Software Systeme GmbH Fax: +49 7144 8144-10
Riedbachstrasse 5
74385 Pleidelsheim