Jim Dodgen <[EMAIL PROTECTED]> wrote: > Perl is mostly typeless, or more correctly has late dynamic binding. No way > to > tell between a scalar used as a string, or a blob. I see no down side in > having > to specify the SQL_BLOB type when access a BLOB field, I just would help to > have know that. > > JIm Dodgen > >
I think you have misunderstood my suggestion. I'm talking about having the DBD::SQLite code check the type of $blob at runtime, then invoking the appropriate sqlite3_bind api **at runtime** when the type of $blob is well known. The code that does this is inside the DBD::SQLite and is never seen by the person using DBD::SQLite. > > Quoting [EMAIL PROTECTED]: > > > So in the example of $sth->execute($blob), if $blob contains an > > integer, use sqlite3_bind_int64(), or if $blob contains a string > > use sqlite3_bind_text(), or if $blob contains a blob, then use > > sqlite3_bind_blob(), and so forth. > > > > Is there something about perl internals that prevents the above > > from working? > > > > -- > > D. Richard Hipp <[EMAIL PROTECTED]> > > > > > > > > > > > .
