Re: [sqlite] strange behaviour on sqlite shell output…

2017-04-18 Thread Hick Gunter
org> Betreff: Re: [sqlite] strange behaviour on sqlite shell output… On 18 April 2017 at 16:28, Hick Gunter <h...@scigames.at> wrote: > Richard Hipp wrote: > >I think the OP is referring to a problem that comes up because the > >field > width and precision of a printf(

Re: [sqlite] strange behaviour on sqlite shell output…

2017-04-18 Thread Rowan Worth
On 18 April 2017 at 16:28, Hick Gunter wrote: > Richard Hipp wrote: > >I think the OP is referring to a problem that comes up because the field > width and precision of a printf() format are measured in bytes, not > characters, and if the input is multi-byte UTF then it is

Re: [sqlite] strange behaviour on sqlite shell output…

2017-04-18 Thread Hick Gunter
>On 4/18/17, Hick Gunter wrote: >> I don't see any calls to sqlite3() functions in your "isolated test case". >> Maybe you are having problems with character encoding outside of sqlite? > >I think the OP is referring to a problem that comes up because the field width >and

Re: [sqlite] strange behaviour on sqlite shell output…

2017-04-18 Thread Richard Hipp
On 4/18/17, Hick Gunter wrote: > I don't see any calls to sqlite3() functions in your "isolated test case". > Maybe you are having problems with character encoding outside of sqlite? I think the OP is referring to a problem that comes up because the field width and precision of

Re: [sqlite] strange behaviour on sqlite shell output…

2017-04-18 Thread Hick Gunter
Montag, 17. April 2017 10:55 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] strange behaviour on sqlite shell output… Am 17.04.2017 um 10:34 schrieb aotto: ……… This is the isolated test case this shows the BUG #include "stdio.h" int ma

Re: [sqlite] strange behaviour on sqlite shell output…

2017-04-17 Thread aotto
Am 17.04.2017 um 10:34 schrieb aotto: ……… This is the isolated test case this shows the BUG #include "stdio.h" int main ( int argc, char **argv ) { // code int i=3; int w=11; // → ?? int nArg=4; char *rowSep="\n"; char *azArg[4] = {NULL,NULL,NULL,"EO EU WE €O

Re: [sqlite] strange behaviour on sqlite shell output…

2017-04-17 Thread aotto
Am 17.04.2017 um 10:26 schrieb aotto: Am 15.04.2017 um 09:49 schrieb aotto: select Reporter, Partner, Year, PartnerCode from [EXEC-BtH0] where Reporter = 'AGO' Hi, I add the following code in shell.c if( w<0 ){ utf8_printf(p->out,"%*.*s%s",-w,-w, azArg[i] ?

Re: [sqlite] strange behaviour on sqlite shell output…

2017-04-17 Thread aotto
Am 15.04.2017 um 09:49 schrieb aotto: select Reporter, Partner, Year, PartnerCode from [EXEC-BtH0] where Reporter = 'AGO' Hi, I add the following code in shell.c if( w<0 ){ utf8_printf(p->out,"%*.*s%s",-w,-w, azArg[i] ? azArg[i] : p->nullValue,

[sqlite] strange behaviour on sqlite shell output…

2017-04-15 Thread aotto
Hi…i have written a VTAB extension and using SHELL to view the results… + valgrind --leak-check=full --quiet gen/cltdb -column -echo -header gen/.my1 'select Reporter, Partner, Year, PartnerCode from [EXEC-BtH0] where Reporter = '\''AGO'\'' and select Reporter, Partner, Year, PartnerCode from