Re: [sqlite] Limit how much data to read
> Where in the documentation that explains how to use the sqlite substr() > function? Go to the SQLite Syntax page, and click on 'expression'.
RE: [sqlite] Limit how much data to read - substr syntax
Regarding: Where in the documentation that explains how to use the sqlite substr() function? Hi Shawn, >From the main sqlite.org page, take the SYNTAX link, then EXPRESSIONS http://www.sqlite.org/lang_expr.html substr(X,Y,Z) Return a substring of input string X that begins with the Y-th character and which is Z characters long. The left-most character of X is number 1. If Y is negative the the first character of the substring is found by counting from the right rather than the left. If SQLite is configured to support UTF-8, then characters indices refer to actual UTF-8 characters, not bytes. Donald Griggs Opinions are not necessarily those of Misys Healthcare Systems nor its board of directors.
Re: [sqlite] Limit how much data to read
Where in the documentation that explains how to use the sqlite substr() function? Cory Nelson wrote: Try the substr() function On 7/25/05, Shawn Walker <[EMAIL PROTECTED]> wrote: Is there a way to tell sqlite to read up to X bytes? For example, there are some data that can be quite large, but I don't need all of them, just a little bit of it to show the user some of the data and they can select that data to get the rest of the data from the DB.
Re: [sqlite] Limit how much data to read
Try the substr() function On 7/25/05, Shawn Walker <[EMAIL PROTECTED]> wrote: > Is there a way to tell sqlite to read up to X bytes? For example, there > are some data that can be quite large, but I don't need all of them, > just a little bit of it to show the user some of the data and they can > select that data to get the rest of the data from the DB. > -- Cory Nelson http://www.int64.org
[sqlite] Limit how much data to read
Is there a way to tell sqlite to read up to X bytes? For example, there are some data that can be quite large, but I don't need all of them, just a little bit of it to show the user some of the data and they can select that data to get the rest of the data from the DB.