Re: Storageformat of Decimal values ...

[Hagen Höpfner]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> No, it depends on the "pointer" size. (not C pointer, but a pointer to a
> record - a record number for a fixed row_format). In MyISAM a record
> cannot be shorter than a pointer size. Try to create, say, 8 decimal
> (1,0) fields, you'll see that every single one of then takes only one
> byte.

Ok, but now let's come back to my initial question ;-) How to map a
decimal value mapped to a bit sequence ... is it similar to
real/float/double (IEEE 754) or do you use another method? Where can I
find a detailed documentation about at least: how many bytes are
required for what kind of decimal? You mentioned (1,0) requires one byte
... I know (18,9) requires 8 bytes (one byte for 9 digits) and (20,10)
requires 10 bytes. But what happens in between?

I know this are a lot of questions, but I am really interested in
understanding it (without analyzing all the source code in detail ;-) ) ...

Thanx a lot,

Hagen



- --
- ------------------------------------------------------------
Dr.-Ing. Hagen Höpfner | hoepfner@stripped | [phone]
- ------------------------------------------------------------
         http://www.i-u.de/schools/hopfner/index.html

             International University in Germany
               School of Information Technology
                  Campus 3  D-76646 Bruchsal
- ------------------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: GnuPT 2.6.0 by EQUIPMENTE.DE
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFClFicataeEpWdQtYRAjL0AKCIGrmrKMLAyVj1dFqWtwOMGnaJ4gCfR83k
0inSmtPBrYRiv9XO4rHhy8I=
=u2bt
-----END PGP SIGNATURE-----