Oh, sorry. It was my fault. It works very well with starting number 1. :)
2012/6/19 Bart Smissaert <[email protected]> > 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 <[email protected]> wrote: > > 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 one plus value to get correct > > length of string. > > I'm using sqlite 3.7.13 legacy source code and compiled on my Ubuntu > server > > 10.04 64bit. > > > > Thank you for read this message. > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
