vdechef
vdechef
@dumblob while waiting for experts to answer his question, I checked the code of mysqldump to see if there are other cases than blobs that use hexadecimal notation. I got...
@crupest You are right, I also though about data being inserted as hex by someone, then dumped by mysqldump. But my guess was that those values would be dumped as...
I did some research in MySQL data types documentation, and also some tests to validate that what I understood from documentation was right. Here are my findings. Available data types...
Some thoughts about corner cases : * what about `extended inserts` options ? It will break mysql2sqlite script, shouldn't we warn about it ? * what about `INSERT DELAYED` ?...
@dumblob As long as you use --hex-blob, yes, it will be output as hex.
> Thinking about it further, I'd leave it in the script if someone really can't or doesn't want to use the `--hex-blob` option, then `BIT`s will get converted. But we...
> > > what about `extended inserts` options ? It will break mysql2sqlite script, shouldn't we warn about it ? > > Such cases should be solved by disabling them...
I will try to address this in #71 because I will have to change the way BIT are parsed. So it would be the right time to improve other types...
I will try to address this in #71 because I will have to change the way BIT are parsed. So it would be the right time to improve other types...
This issue is linked to #69