At current, the csv extension fails to open Unicode file names like

  CREATE VIRTUAL TABLE t1 USING csv(
    filename = "äöü.csv");

because internally the filename is passed to fopen() as UTF-8:

  http://www.sqlite.org/src/artifact/816a3715356e4210?ln=131

However, fopen() does not honor UTF-8, at least not on Windows:

  https://msdn.microsoft.com/en-us/library/yeby3zcb.aspx

Could it be possible to replace fopen() and related functions with the respective VFS functions instead?

This would also remove dependency on stdio, which is otherwise carefully avoided in the SQLite library (except for testing etc.).

Ralf
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to