PDA

View Full Version : BLOB size

GNiewerth
05-24-07, 12:06
Hi,

I´m having troubles with blob storage and SQLite3. SQLite3 converts binary data into hexadecimal values, blowing up needed space by factor 2. Unfortunately my application generates huge amounts of binary data, so my database file grows extremely fast.
Is it possible to store binary data in raw format that occupies just as many space as the binary data?

Thank you in advance,
Guido
GNiewerth
05-25-07, 04:28
Problem resolved, it was the SQL editor that made me think BLOBS are encoded as 2 byte. When I openend the db file with an hex editor I discovered that BLOBS are stored in binary.

Guido