Hi,

I'm working on an application that analizes music similarity. In order to do that I proccess audio data and store the results in txt files. For each audio file I create 2 files, 1 containing and 16 values (each value can be like this:2.7000023942731723) and the other file contains 16 rows, each row containing 16 values like the one previously shown.

I'd like to store the contents of these 2 file in a table of my MySQL database.

My table looks like:

Name varchar(100) Author varchar (100)

in order to add the content of those 2 file I think I need to use the BLOB data type:

file1 blob file2 blob

My question is how should I store this info in the data base? I'm working with Java where I have a double array containing the 16 values (for the file1) and a matrix containing the file2 info. Should I process the values as strings and add them to the columns in my database?

Thanks