Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

2009-12-14 Thread Jean-Denis Muys
On 12/13/09 16:34 , Jay A. Kreibich j...@kreibi.ch wrote: On Sun, Dec 13, 2009 at 01:47:43PM +0300, Alexey Pechnikov scratched on the wall: On Sunday 13 December 2009 02:09:48 Roger Binns wrote: The libsqlite is locale-independent but sqlite3 shell linked with readline and it's

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

2009-12-14 Thread Jay A. Kreibich
On Mon, Dec 14, 2009 at 10:41:04AM +0100, Jean-Denis Muys scratched on the wall: On 12/13/09 16:34 , Jay A. Kreibich j...@kreibi.ch wrote: On Sun, Dec 13, 2009 at 01:47:43PM +0300, Alexey Pechnikov scratched on the wall: On Sunday 13 December 2009 02:09:48 Roger Binns wrote: The

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

2009-12-14 Thread Nicolas Williams
On Sat, Dec 12, 2009 at 12:39:23PM -0800, Roger Binns wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexey Pechnikov wrote: On unix the shell must do this initialisation: setlocale(LC_ALL, ); Why? Yes I know what the call does, but what desirable effect does it have on

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

2009-12-14 Thread Jean-Denis Muys
On 12/14/09 16:56 , Jay A. Kreibich j...@kreibi.ch wrote: On Mon, Dec 14, 2009 at 10:41:04AM +0100, Jean-Denis Muys scratched on the wall: So Jay, what you are saying is that SQLite doesn't have to provide bug-free features when those features are optional? [snip] So, yes, I'm saying,

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

2009-12-13 Thread Alexey Pechnikov
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

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

2009-12-13 Thread Jay A. Kreibich
On Sun, Dec 13, 2009 at 01:47:43PM +0300, Alexey Pechnikov scratched on the wall: 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.

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

2009-12-13 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexey Pechnikov wrote: 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.

[sqlite] BUG: The sqlite3 shell does not call setlocale

2009-12-12 Thread Alexey Pechnikov
Hello! On unix the shell must do this initialisation: setlocale(LC_ALL, ); Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

2009-12-12 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexey Pechnikov wrote: On unix the shell must do this initialisation: setlocale(LC_ALL, ); Why? Yes I know what the call does, but what desirable effect does it have on shell input and output? Pretty much all formatted output is done using %s.

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

2009-12-12 Thread Alexey Pechnikov
Hello! On Saturday 12 December 2009 23:39:23 Roger Binns wrote: setlocale(LC_ALL, ); Why? Yes I know what the call does, but what desirable effect does it have on shell input and output? Pretty much all formatted output is done using %s. The only float output is for timing commands. No

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

2009-12-12 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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