Re: SELECT into OUTFILE (binary formats?) - workaround - solved

[admin www.mercuriusgids.nl]

Its possible though. Currently dumping in binary formats. Still need to use delimiters though. The answer is to use bitshifting in combination with char()

ie.

select
char( (data>>16)&0xFF ), --first byte
char( (data>>8)&0xFF ), --second etc
char( (data>>0)&0xFF )
into outfile etc.....

For me, this is sufficient. Also the load infile works ...
You can use bit(24), binary(3) etc.

Using the technique above dumped values are always left padded and the right size.

I need also maximum number of records to read and start/end offset so i guess i am going to modify some mysql source :)

Cheers