On Wed, 2006-04-19 at 09:33 +0200, Hagen Höpfner wrote:
> perhaps a stupid question but I need to know it ;-) The internals
> documentation describes how MyISAM stores attribute values physically
> (text encoding, date transformation, etc. ...). How is this done in
> InnoDB or BDB? I know that InnoDB uses it's own dataset format. Does the
> binary encoding of the attribute values differs too? And ... if not, is
> it equal for all MySQL storage engines?
As Serg has said, it differs.
The conversion routines are in the handlers for each storage engine -
sometimes in different ways. Have a look at what csv (ha_tina) does. NDB
(ha_ndbcluster) has a function that does it all IIRC.
Sometimes the conversion is a no-op.
Some engines can just use the internal row format (I think ARCHIVE does
this).
--
Stewart Smith, Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@stripped
Mobile: +61 4 3 8844 332
Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc