in reply to MySQL pack?

If your string is only 1 and 0 you could simply treat it like a number and convert it to another base. Hex or base10. This would shrink your representation of the data, if you have to query the table, just convert your query string prior to running it.

This may also make it easier to handle the data.
You may have to split your data up into several strings, depending on the limitations of the conversion program. so as and example 00111011101010000110 => 0011101+1101010+000110 => 48863+545345+879

Replies are listed 'Best First'.
Re: Re: MySQL pack?
by diotalevi (Canon) on Apr 13, 2003 at 06:56 UTC

    At this point MIME's base64 would be attractive as well.

      How would base64 improve over pack 'B*'?

      Does MySQL have a mechanism for un-base64ing on the fly?

        Two potential benefits - the packaged data uses only normal characters so the data is easily worked with. Also, Flame didn't ever indicate how zie intended to use it so I've no idea whether the pack/unpack function needs to be present in MySQL or may be external.