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

Reply via email to