Re: [sqlite] BLOB support and SQLite 3.0

2003-12-15 Thread Mrs. Brisby
On Mon, 2003-12-15 at 09:37, D. Richard Hipp wrote: >(2) The ".dump" command will only show the binary data through >the first \000 character. If the binary data contains no >\000 characters, the ".dump" command might segfault. Add an SQL function like TOCHAR or something

[sqlite] BLOB support and SQLite 3.0

2003-12-15 Thread D. Richard Hipp
Mrs. Brisby wrote: [...] I really would like to see user-defined "structures"- but I suspect this will have to wait for SQLite 3.0 or whenever we get non-null-terminating values... You can do that now. The (experimental) sqlite_bind() API available in 2.8.7 allows you to insert arbitrary binary