ce are
> combined: nothing works and no one knows why.
>
>
> >-Original Message-
> >From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-
> >bounces at mailinglists.sqlite.org] On Behalf Of David Barrett
> >Sent: Sunday, 1 March, 2015 11:41
On 2015-03-01 08:40 PM, David Barrett wrote:
> Hi! If I define a column as BLOB type, will length() run strlen() on the
> data, or will it consult some kind of internal value to determine the
> length? The documentation says:
>
> "For a string value X, the length(X) function returns the number
On 1 Mar 2015, at 6:40pm, David Barrett wrote:
> I'm wondering if I insert
> a string into that blob if it'll return the blob length or the string
> length.
You can put a value of any type into a column of any affinity. i.e. you can
put a BLOB into a BLOB column or a string into a BLOB column
ssage-
>From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-
>bounces at mailinglists.sqlite.org] On Behalf Of David Barrett
>Sent: Sunday, 1 March, 2015 11:41
>To: General Discussion of SQLite Database
>Subject: [sqlite] Does length() use strlen() on b
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/01/2015 10:40 AM, David Barrett wrote:
> Hi! If I define a column as BLOB type, will length() run strlen()
> on the data, or will it consult some kind of internal value to
> determine the length?
sqlite> select cast(x'424446' as text);
BDF
sqli
Hi! If I define a column as BLOB type, will length() run strlen() on the
data, or will it consult some kind of internal value to determine the
length? The documentation says:
"For a string value X, the length(X) function returns the number of
characters (not bytes) in X prior to the first NUL ch
6 matches
Mail list logo
