Example of blob storage and retrieval in mysql for an audio file using C#

Question

Can anyone give me an example of how to use BLOB in MySQL?

For example, how to insert value into a table if the data type is declared as BLOB.

This is for an audio file.

Marco · Accepted Answer · 2011-04-01 14:01:20Z

1

Just an example how to get a BLOB:

private byte[] GetBlob(MySqlDataReader rd, string field, Int32 len)
{
    byte[] ret = new byte[len];
    if (len > 0) rd.GetBytes(rd.GetOrdinal(field), 0, ret, 0, len);
    return ret;
}

To insert an audio file you could use byte[] f=File.ReadAllBytes() and then use f as parameter in an insert command.

answered Apr 1, 2011 at 14:01

Marco

57.7k15 gold badges135 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

increddibelly · Accepted Answer · 2011-03-16 12:56:39Z

0

you may want to have a look here: http://aspalliance.com/1093_Serialization_in_Database.all

also - as a side note, this site may help you as well: http://www.netmanners.com/email-etiquette/email-etiquette-101/

answered Mar 16, 2011 at 12:56

increddibelly

1,2691 gold badge15 silver badges25 bronze badges

Collectives™ on Stack Overflow

Example of blob storage and retrieval in mysql for an audio file using C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related