You store them in the DB as a BLOB type, but save the data as a JPEG,
MP3, WAV or whatever it happens to be. The binary data resides as a DB
column and the same row may have other columns which could be text to
describe the item or a number to store the size etc.
sebcity wrote:
Ok,so just save them as BLOB files?
Igor Tandetnik wrote:
sebcity <[EMAIL PROTECTED]> wrote:
Is it possible to store mp3 files in a SSQLite database? would they
be able to be played from the database? How would you save them?
SQLite does not know anything nor care about music or MP3. It can store
strings (e.g. file names), BLOBs (binary data, e.g. contents of said
files) and numbers. You could retrieve the raw data from the database
(or from the file referred to by the database, depending on your chosen
storage scheme) and give it to something that would interpret the data
as music and play it.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
