On 15 Nov 2019, at 20:13, Winfried <[email protected]> wrote: > I have a big CSV file that's encoded in Latin1 (cp1252), while SQLite stores > strings as Unicode. > > Neither Google nor ".help" helped to find if SQLite offers a switch to > convert Latin1 to UTF-8 on the fly before running the ".import" command. > > Should I first convert the file into UTF-8 before importing it into SQLite?
Far as I know, SQLite stores your text as UTF-8 and you have to do the conversion yourself. I think there's a UTF-16 option too. I'd start here: https://www.sqlite.org/faq.html -- Cheers -- Tim _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
