14 Jun
2015
14 Jun
'15
5:29 a.m.
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'