I have BLOBs in my schema and the data will often start with bytes of 0
value.
I'm having a tough time coming up with the proper SQL syntax to select all
the columns that start with 2 0's (or any zeros).
I have tried:
SELECT * FROM mytable WHERE myblob LIKE 0%;
SELECT * FROM mytable WHERE
I don't know if what I want to do is possible or not.
I have a schema that has a couple of BLOB columns where the data is
either:
1. Really random, or
2. May contain leading 0's
Either way, the results aren't really readable with SELECT using the
sqlite command line tool. Are there any
Thanks very much, the quote() helps a lot.
On Mon, 30 Jan 2006 [EMAIL PROTECTED] wrote:
Shane Baker [EMAIL PROTECTED] wrote:
Are there any mechanisms that will display the [BLOB]
data in a human readable format?
Assuming the table is: CREATE TABLE t1(x BLOB)
You can do this:
SELECT
I have the same question. Specifically, what indication is there that no
primary key was created.
Certainly, by executing the command below (using the sqlite3 command tool)
verbatim and following that with .schema indicates that the table was
created with a primary key.
This is with 3.2.7 on
I'm going to state right up front that I have very little experience with
sqlite and, if I can help demonstrate that this ticket is valid, I will.
That said, it comes as no surprise that I had never looked at
sqlite_master before. So, I checked out the contents and found that, with
my very
No, as I mentioned in my original message, I am not wrapping them. I
don't want to test an unrealistic scenario for my application. In my
application, there are multiple sources that will be inserting into the
database and pooling the information for a bulk insert won't work.
I understand that
Nov 2005, Shane Baker wrote:
I'm sure I must be doing something wrong. This is my first attempt at
working with SQLite.
We'll see...
I have a simple table, with 7 columns. There are 6 integers and a BLOB,
with the primary key being on an integer. When I try to run inserts (one
insert
Thank you very much. I am happy to hear that the performance I am seeing
is in line with what others have observed. I am running this on Windows
XP.
On Tue, 22 Nov 2005, Akira Higuchi wrote:
Hi,
On Mon, 21 Nov 2005 10:56:41 -0500 (EST)
Shane Baker [EMAIL PROTECTED] wrote:
I just need
