techouse / mysql-to-sqlite3

Transfer data from MySQL to SQLite
https://techouse.github.io/mysql-to-sqlite3/
MIT License
217 stars 31 forks source link

add NOCASE params when mysql is no case in default #18

Closed luyinhua closed 3 years ago

luyinhua commented 3 years ago

mysql default is NOCASE in char/varchar/text field , but sqlite is default is not nocase ,can the command add a params to change nocase info

such as

CREATE TABLE User (UserName NVARCHAR(20) COLLATE NOCASE);

techouse commented 3 years ago

Hey,

Thanx for the idea proposal. I'll add it probably over the coming weekend. :)

techouse commented 3 years ago

Added -C, --collation CLI option. It defaults to BINARY just like specified in the SQLite docs.