C# Unity3D playing a .wav saved as BLOB in SQLite database

Question

I have a database with different words in it, and with the words is a wav file stored in a blob with the pronunciation. I'm stuck trying to get the BLOB to read as a AudioClip for Unity.

So far I have the sound file somewhat resembling my original in the fact that its the same length, but there's a lot of static.

private float [] ConvertByteToFloat ( byte [] array )
{
    float[] floatArr = new float [ array.Length / 4 ];
    for ( int i = 0; i < floatArr.Length; i++ )
    {
        if ( !System.BitConverter.IsLittleEndian )
            System.Array.Reverse( array, i * 4, 4 );
        floatArr [ i ] = System.BitConverter.ToSingle( array, i * 4 );
    }
    return floatArr;
}
float[] stream = ConvertByteToFloat((byte[]) reader["Sound"]);
AudioClip clip = AudioClip.Create( ( string ) reader [ "Name" ], stream.Length, 2, 44100, false, false );
clip.SetData( stream, 0 );

There was only static earlier when IsLittleEndian was if(true), if not true made it a little more accurate, but still not what it was before.

score 0 · Answer 1 · answered Jul 09 '14 at 23:29

0

Your question is how to read AudioClip data from memory? Use AudioClip.SetData API. For example,

AudioClip audioClip = AudioClip.Create("Sound", data.Length, 1, 44100, false, false);
audioClip.SetData(data, 0);

Or you can use AudioClip AssetBundle from sqlite3 blob data via AssetBundle.CreateFromMemory if you have Pro license.

answered Jul 09 '14 at 23:29

Kazuki Sakamoto

13,929
2
34
96

I forgot to copy that line at the end, I do have clip.SetData( stream, 0 ); I went back to it just now and its sounding a little bit smoother, but not without static. I also do not have pro. – Narayana James Emery Jul 09 '14 at 23:48
**stream** should be floats ranging from 0.0f to 1.0f. reader["Sound"] is the exactly same as wav file? you should decode wav file into raw floats. – Kazuki Sakamoto Jul 09 '14 at 23:54
I saw in one of the comments about PCM is wavs, I'm going to check that and get back here tomorrow. – Narayana James Emery Jul 10 '14 at 01:03
Setting the PCM is a delegate, not sure what to do for that. – Narayana James Emery Jul 11 '14 at 18:17

C# Unity3D playing a .wav saved as BLOB in SQLite database

1 Answers1