Re: [sqlite] Bug wit length() SQL Query function

2007-02-26 Thread venkat akella
Thanks Rechard and Gerry for the quick reply. I will use that alternative solution. Is there any easy way to get the size of data stored in a table, size of a row usig Sqlite C APIs? Venkat. On 2/26/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "venkat akella" <[EMAI

[sqlite] Bug wit length() SQL Query function

2007-02-26 Thread venkat akella
Hi lenght() function in SQL Query is not behaving properly. I have explained this below with an example. Select length(col1) + length(col2) + length(col3) + length(col4) from TestTable; For example, there are four columns in a table and in a row three columns (col1, col2 and col3) have