Re: [sqlite] substr bug in 3.7.13?

Oh, sorry. It was my fault. It works very well with starting number 1. :) 2012/6/19 Bart Smissaert > Should that zero not be a 1? > From the documentation: > The left-most character of X is number 1 > > RBS > > > On 6/19/12, Yongil Jang wrote: >

Re: [sqlite] substr bug in 3.7.13?

Should that zero not be a 1? >From the documentation: The left-most character of X is number 1 RBS On 6/19/12, Yongil Jang wrote: > Dear all, > > I've found following result when I try to use 'substr' function. > > sqlite> create table test (data text); > sqlite> insert

[sqlite] substr bug in 3.7.13?

Dear all, I've found following result when I try to use 'substr' function. sqlite> create table test (data text); sqlite> insert into test values ('010101'); sqlite> select substr(data, 0, 2) from test; 0 sqlite> select substr(data, 0, 3) from test; 01 As you can see, string length should be