Hello!
On Sunday 13 December 2009 02:09:48 Roger Binns wrote:
> Alexey Pechnikov wrote:
> > This is standart for all i18n applications.
>
> The SQLite shell is not an i18n application, and this is deliberate. It is
> a developer tool. That is why for example it always uses a dot for a
> decimal point and not a comma even if that is what the locale does. The
> output is always the same wherever it is used. (Same thing applies for
> input.)
The libsqlite is locale-independent but sqlite3 shell linked with readline and
it's locale-dependent.
> > The SQLite virtualtables can
> > perform access to filesystem, read/write scv files and other - how they can
> > to
> > determine the current locale?
>
> That is indeed trickier. But even your example is hard. If I am sitting in
> Canada and get a German CSV file, which locale applies?
The locale of CSV file may be defined in virtualtable arguments like to
create virtual table test using VirtualText
('/srv/projects/work/billing/export/ats.csv','utf8','','.',',',',');
But _default_ may be system locale. How to do filesystem access in a
virtualtable without locale
information?
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
