SQLite how to declare as Byte Array?

Question

I've got a SQLite database. I'd like to create a field and declare it as type Byte array but I don't know what SQLite calls something that would be of type Byte Array. How would I do this?

kjlubick · Accepted Answer · 2012-11-08 16:25:03Z

65

You're looking for BLOB.

From the webpage:

BLOB - The value is a blob of data, stored exactly as it was input.

Here's an example of making a table with two columns - an id and some data, which is a BLOB:

CREATE TABLE t1 (id INTEGER PRIMARY KEY, data BLOB);

edited Nov 8, 2012 at 16:25

kjlubick

1,34812 silver badges32 bronze badges

answered Jul 19, 2010 at 10:11

sarnold

105k23 gold badges187 silver badges243 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jarda · Accepted Answer · 2015-07-13 10:37:34Z

5

To add an info - official is BLOB, but when building SQLite DB is Visual studio, use type "image" which is the alias for BLOB

answered Jul 13, 2015 at 10:37

Jarda

5961 gold badge11 silver badges35 bronze badges

Collectives™ on Stack Overflow

SQLite how to declare as Byte Array?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related