Android Question MSMariaDB/MSMySQL upload blob (audio in example) to db ?

[Magma]

Hi there...

i want just upload audio / blob to my db... (using MSMariaDB library)

Must convert bytes to string ? and how ?
Or easily can upload blob.. someway ?

example using audio library..

Sub Process_Globals
   Dim astream As AudioStreamer
   Dim myaudio As List   
   Dim nowrecord As Boolean
end sub

Sub Button1_Click

If nowrecord=False Then
    Button1.textColor=Colors.red
    nowrecord=True
    Log("recording")
    myaudio.clear
    astream.StartRecording
Else
    astream.StopRecording
'    Log("playing")
'    astream.StartPlaying 'This is for playing :)
'   For Each b() As Byte In myaudio
'      astream.Write(b)
'   Next
'    astream.Write(Null)
'write to db

'HOW ?
....................

    nowrecord=False
    Button1.textColor=Colors.Green
End If   
End Sub

 

[KMatle]

Must convert bytes to string ? and how ?

I do it that way (because it's easier to handle). See here: https://www.b4x.com/android/help/byteconverter.html#byteconverter_stringfrombytes

Another example: https://www.b4x.com/android/forum/threads/b4x-bytes-to-file.70111/

To be compatible to any system I do a convert to a Base64 string, too (pro: easy to handle, con: the data gets bigger).

PS: You can use the search function for such cases. There are tons of examples.

 

[Magma]

@KMatle when u saying - get bigger... how ?

So then after converting to string just making the statement of INSERT and using it like a simple string...

  db.ExecuteASync("INSERT INTO audiofilestable SET audiofile='" & audiostring & "' ;","")

audiofile field will be a LONGTEXT ?