On 11/15/19 4:45 PM, Winfried wrote: > It's odd that SQLite doesn't support this, since it's not uncommun to have > big Latin1 input files that can take a while to load in eg. Excel. > > For others' benefit, GNUWin32's iconv is very fast: > > "C:\Program Files\GnuWin32\bin\iconv.exe" -f "windows-1252" -t "UTF-8" > "input.1252txt" > "output.UTF8.txt" > > Thank you. > I think it is because SQLite expect the application to handle any such needed conversion.
Note that .import isn't an SQL command, but a command line in the SQLite shell. I don't think the shell is intended to be a 'Do Everything' tool, but a convenience and quick operation tool. As you command line operation shows, it isn't that hard to do the operation with other tools. -- Richard Damon _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users