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
