PACKET_BINDATA

This packet type in the binary protocol transfers result set row data in a compact binary format, determined by the column types returned in metadata.

In contrast to the text protocol, the binary protocol transfers data according to the format of the field types returned in PACKET_METADATA.

Field type	Representation
MYSQL_TYPE_BIT	str_LEC
MYSQL_TYPE_BLOB	str_LEC
MYSQL_TYPE_DATE MYSQL_TYPE_DATETIME MYSQL_TYPE_TIMESTAMP	int_11 (default)int_7 (no microseconds)int_4 (no time values)int_0 (no values)
MYSQL_TYPE_DECIMAL	str_LEC
MYSQL_TYPE_DOUBLE	int_8
MYSQL_TYPE_ENUM	str_LEC
MYSQL_TYPE_FLOAT	int_4
MYSQL_TYPE_GEOMETRY	str_LEC
MYSQL_TYPE_INT24	int_4
MYSQL_TYPE_JSON	str_LEC
MYSQL_TYPE_LONGLONG	int_8
MYSQL_TYPE_LONG_BLOB	str_LEC
MYSQL_TYPE_LONG	int_4
MYSQL_TYPE_MEDIUM_BLOB	str_LEC
MYSQL_TYPE_NEWDECIMAL	str_LEC
MYSQL_TYPE_NULL	stored in bitmap
MYSQL_TYPE_SET	str_LEC
MYSQL_TYPE_STRING	str_LEC
MYSQL_TYPE_SHORT	int_2
MYSQL_TYPE_TINY_BLOB	str_LEC
MYSQL_TYPE_TINY	int_1
MYSQL_TYPE_VARCHAR	str_LEC
MYSQL_TYPE_VAR_STRING	str_LEC
MYSQL_TYPE_YEAR	int_4

Fields

(column_count + 7)/8   null bitmap
while (!eof) {
  for (i=0; i < column_count; i++)
  {
    data (length depends on the data type)
  }
}

_{This page is licensed: CC BY-SA / Gnu FDL}