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
