The script generates invalid SQL when data contains single quotes.
Steps to reproduce:
curl -O https://gnivc.ru/html/gnivcsoft/KLADR/Base.7z
7zr x Base.7z
sqlite3-dbf STREET.DBF | iconv -f cp866 -t utf8 | grep 56000004000969900
Result:
INSERT INTO street VALUES('СНТСН № 15 совхоза 'Садовод'','тер','56000004000969900','462401','5614','','53423000000');
(leads to "Error: near "Садовод": syntax error" in sqlite3)
Expected:
INSERT INTO street VALUES('СНТСН № 15 совхоза ''Садовод''','тер','56000004000969900','462401','5614','','53423000000');
The script generates invalid SQL when data contains single quotes.
Steps to reproduce:
Result:
(leads to "Error: near "Садовод": syntax error" in sqlite3)
Expected: