Re: [sqlite] SQLite 3.6.17

2009-09-04 Thread Alberto Simões
On Thu, Sep 3, 2009 at 10:30 PM, Nicolas Williams wrote: > On Thu, Sep 03, 2009 at 03:27:38PM +0100, Simon Slavin wrote: > > On 3 Sep 2009, at 1:38am, P Kishor wrote: > > > well, I think the problem is with the sqlite3 command line tool. > > I agree. I just checked it with OS X 10.6, which comes

Re: [sqlite] SQLite 3.6.17

2009-09-03 Thread Nicolas Williams
On Thu, Sep 03, 2009 at 03:27:38PM +0100, Simon Slavin wrote: > On 3 Sep 2009, at 1:38am, P Kishor wrote: > > well, I think the problem is with the sqlite3 command line tool. > I agree. I just checked it with OS X 10.6, which comes with SQLite > version 3.6.12, and got the same problem: you can'

Re: [sqlite] SQLite 3.6.17

2009-09-03 Thread Simon Slavin
On 3 Sep 2009, at 1:38am, P Kishor wrote: > well, I think the problem is with the sqlite3 command line tool. I agree. I just checked it with OS X 10.6, which comes with SQLite version 3.6.12, and got the same problem: you can't type accented characters into the sqlite3 tool. So I guess the

Re: [sqlite] SQLite 3.6.17

2009-09-02 Thread P Kishor
On Wed, Sep 2, 2009 at 6:14 PM, Simon Slavin wrote: > > On 2 Sep 2009, at 8:27pm, P Kishor wrote: > >> Simon >> Slavin wrote: >>> >>> On 2 Sep 2009, at 2:39pm, Alberto Simões wrote: >>> Can you please send me your env? >>> >>> It works fine for me on Leopard, and I have done no special >>> env

Re: [sqlite] SQLite 3.6.17

2009-09-02 Thread Simon Slavin
On 2 Sep 2009, at 8:27pm, P Kishor wrote: > Simon > Slavin wrote: >> >> On 2 Sep 2009, at 2:39pm, Alberto Simões wrote: >> >>> Can you please send me your env? >> >> It works fine for me on Leopard, and I have done no special >> environment setting at all: I use the default Unix settings and the

Re: [sqlite] SQLite 3.6.17

2009-09-02 Thread P Kishor
2009/9/2 Alberto Simões : > Simon, try to compile a gnu version of readline, and then compile sqlite > againt it. It should do the trick. actually, it is me, not Simon, who is experiencing this problem. Before I jump into compiling a new readline lib, I want to ascertain if that is what others (s

Re: [sqlite] SQLite 3.6.17

2009-09-02 Thread Alberto Simões
Simon, try to compile a gnu version of readline, and then compile sqlite againt it. It should do the trick. All the best, Alberto On Wed, Sep 2, 2009 at 8:27 PM, P Kishor wrote: > On Wed, Sep 2, 2009 at 10:55 AM, Simon > Slavin wrote: > > > > On 2 Sep 2009, at 2:39pm, Alberto Simões wrote: > >

Re: [sqlite] SQLite 3.6.17

2009-09-02 Thread P Kishor
On Wed, Sep 2, 2009 at 10:55 AM, Simon Slavin wrote: > > On 2 Sep 2009, at 2:39pm, Alberto Simões wrote: > >> Can you please send me your env? > > It works fine for me on Leopard, and I have done no special > environment setting at all: I use the default Unix settings and the > default SQLite setti

Re: [sqlite] SQLite 3.6.17

2009-09-02 Thread Simon Slavin
On 2 Sep 2009, at 2:39pm, Alberto Simões wrote: > Can you please send me your env? It works fine for me on Leopard, and I have done no special environment setting at all: I use the default Unix settings and the default SQLite settings for 10.5. You might want to check which shell you're usi

Re: [sqlite] SQLite 3.6.17

2009-09-02 Thread Alberto Simões
On Wed, Sep 2, 2009 at 2:52 PM, D. Richard Hipp wrote: > > On Sep 2, 2009, at 9:46 AM, D. Richard Hipp wrote: > >>> > >>> It worked for me before. No idea what is happenning. > >> Can you please send me your env? > > > > > > > sqlite-imac:bld drh$ ./sqlite3 > SQLite version 3.6.17 > Enter ".help"

Re: [sqlite] SQLite 3.6.17

2009-09-02 Thread D. Richard Hipp
On Sep 2, 2009, at 9:46 AM, D. Richard Hipp wrote: >>> >>> It worked for me before. No idea what is happenning. >> Can you please send me your env? > > sqlite-imac:bld drh$ ./sqlite3 SQLite version 3.6.17 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create ta

Re: [sqlite] SQLite 3.6.17

2009-09-02 Thread D. Richard Hipp
On Sep 2, 2009, at 9:39 AM, Alberto Simões wrote: Hello, drh. On Wed, Sep 2, 2009 at 2:28 PM, D. Richard Hipp wrote: Works for me: sqlite-imac:bld drh$ ./sqlite3 SQLite version 3.6.17 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t1(x); s

Re: [sqlite] SQLite 3.6.17

2009-09-02 Thread Alberto Simões
Hello, drh. On Wed, Sep 2, 2009 at 2:28 PM, D. Richard Hipp wrote: > > > > Works for me: > > sqlite-imac:bld drh$ ./sqlite3 > SQLite version 3.6.17 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> create table t1(x); > sqlite> insert into t1 values('Alberto

Re: [sqlite] SQLite 3.6.17

2009-09-02 Thread D. Richard Hipp
On Sep 2, 2009, at 9:06 AM, Alberto Simões wrote: > Hellows > > Noticed today (with SQLite 3.6.17) that I can't insert non latin1 > character > using the sqlite3 shell. > I am running under Mac OS Leopard (not yet the white one), and using > an > unicode terminal. Works for me: sqlite-imac