maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

well the data is binary encoded, i removed the header, only got the
timestamp ok, but not double values and 64bits integer :/

files attached

[image: Imagem inline 1]

create table teste2(
ticker BINARY(68) not null,                  (i think it's a unicode string)
ts timestamp not null field_format='II',   (should be time64_t)
bid double not null field_format='D',       (should be ieee 64bits double)
ask double not null field_format='D',
last double not null field_format='D',
volume bigint UNSIGNED not null field_format='II',  (should be ulong 64bits)
unknown char(2) not null                       (not important value)
)
engine=CONNECT
readonly=1
table_type=bin
option_list='eof=0'
lrecl =110
FILE_NAME='/home/mysql/data/ticks2.dat'

Attachment: ticks.dat
Description: Binary data

Attachment: ticks2.dat
Description: Binary data