mysql2sqlite icon indicating copy to clipboard operation
mysql2sqlite copied to clipboard

Case sensitivity

Open forthrin opened this issue 3 years ago • 1 comments

I see you don't have time to maintain this excellent tool anymore, but anyway here's one more for the heap.

It seems that MySQL is case insensitive by default, while SQLite is case sensitive by default.

Thus, when connecting to the newly created SQLite DB, INSERT IGNORE statements will yield different results when handling duplicates on UNIQUE columns compared to when using the original MySQL DB.

forthrin avatar Apr 30 '22 16:04 forthrin

You're right my time is very limited and I prefer to rather not maintain it than to accept badly reviewed PRs. I should probably write about this in the readme at some point...

Still feel free to make suggestions and ideally a PR how to go about the case sensitivity issue (I didn't check whether it appears also when using the required dump options as described in readme).

dumblob avatar Apr 30 '22 19:04 dumblob