Oh, sorry.
It was my fault.
It works very well with starting number 1. :)
2012/6/19 Bart Smissaert <bart.smissa...@gmail.com>
> 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 <yongilj...@gmail.com> 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
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
