Database Problem, Unknown Information in a Access DataBase by the MEMO type!

[maysam gamini]

Recently i get a project about a clinic software and i have a little problem with the previous database information. so i thought that you are the best one that could answer me, let me describe a little... the previous software has a feature that allow to the doctor to write the patients information by hand writing with a electrical pen, it so like paint brush software and it save this information in the database like bellow, AORtHQTwD4AEAh4CSBEHSBFEgID8BwRIEEU1B0gRRP8BRQgFSBFE/wEEAwE4ABgiIDIJAPT/AgHpIjpFMwkA+J8CAVogOkU4CAD+AwAAAIB/AA8OEvkjjT/PI40/EQAAgD8eKLQBhvAdR4DpyGhwAAAAAAAAAAAAAAIAZ4yvRgAAnp8AACGhwAAAAAAKIgqE+ry+sL1Y4RhHXsCF8iV5DHKLKIJsTICFqxzDyy14ueEKIgmH5jDmMYFA51D5XSIqh+Ow47GwWG2Sug26 :confused: so i don't know what exactly it is, but i guess it could be a Multimedia Format Like jpeg or anything else like that, do you know what it could be, and how can i solve this problem! thank you very much! With best Regards! -- Maysam Gamini Bachelor Of Information Technology Faculty Of Engineering, Isfahan University E-mail address: Mit.gamini@gmail.com E-mail address: Ir.webbiz@gmail.com Phone: +9821-20105677 Cell No: +98912-3778746

[Luc Pattyn]

chances are it is some kind of binary data (a byte array) made readable through Convert.ToBase64String; so call the reverse function, and look at it; maybe save it in a file, give it different extensions, and try opening it. There isn't much data in your example. :)

Luc Pattyn [Forum Guidelines] [My Articles]

---

The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

---

[Leonardo Muzzi]

Seems to me that this is a binary field written in the String Base 64 format. You can try using Convert.FromBase64String to generate a binary stream, then you can try writing this stream as an image to the browser.

Regards, Leonardo Muzzi

[maysam gamini]

Thank You In Advance, I'll try it and send another reply again, and report the result! about the example that i post, it's quite a content of the database field. there is some another here! 1. AORtHQTwD4AEAh4CSBEHSBFEgID8BwRIEEU1B0gRRP8BRQgFSBFE/wEEAwE4ABgiIDIJAPT/AgHpIjpFMwkA+J8CAVogOkU4CAD+AwAAAIB/AA8OEvkjjT/PI40/EQAAgD8eKLQBhvAdR4DpyGhwAAAAAAAAAAAAAAIAZ4yvRgAAnp8AACGhwAAAAAAKIgqE+ry+sL1Y4RhHXsCF8iV5DHKLKIJsTICFqxzDyy14ueEKIgmH5jDmMYFA51D5XSIqh+Ow47GwWG2Sug26 2. AL5cHQTeD7IDAhsCSBEHSBFEgID8BwRIEEU1CkgRVw0AAABQ/wEEAwE4ABgiIDIJAPT/AgHpIjpFMwkA+J8CAVogOkU4CAD+AwAAAIB/AA8OEvkjjT/PI40/EQAAgD8eJ5kBhfcye5jAAAAAijAAAAAAAAAAAAABdfBBGBIlAAEGAtg4IzHHYApKHoT7Gb7GficXVrxWaMOKtqzx4WHVFSk6RzwAhfIVeQrw2HpowMODnwc9sEFVGAuxkGMqoughqviAhONqlDfjinGcKk 3. ANKqAR0EtA+IBAIOAkgRBUgRRP8BBEgQRTUEAwE4ABgiIDIJAPT/AgHpIjpFMwkA+J8CAVogOkU4CAD+AwAAAIB/AA8OEvkjjT/PI40/EQAAgD8eL6sCgoAAAAAAAAAAAePIAABmgAAAAAAAAePIAAAAAASkoAAAAAACKAAAABmgAAAACkYfhPsVvsZ8zMlKSmONp2rivSsZ3VjdwOWAhfCKeEzxjGSUTTRQyz4Gu/C130zoJLJqsIx0YIP0tMefm5qZtCJImS98/D6oCi

[Leonardo Muzzi]

Well, it's definitely a String Base 64, 'cause I was able to build a byte array from it with this code:

    string strData = @"AORtHQTwD4AEAh4CSBEHSBFEgID8BwRIEEU1B0gRRP8BRQgFSBFE/wEEAwE4ABgiIDIJAPT/AgHpIjpFMwkA+J8CAVogOkU4CAD+AwAAAIB/AA8OEvkjjT/PI40/EQAAgD8eKLQBhvAdR4DpyGhwAAAAAAAAAAAAAAIAZ4yvRgAAnp8AACGhwAAAAAAKIgqE+ry+sL1Y4RhHXsCF8iV5DHKLKIJsTICFqxzDyy14ueEKIgmH5jDmMYFA51D5XSIqh+Ow47GwWG2Sug26";
    byte\[\] data = Convert.FromBase64String(strData);

The problem is, I wasn't able to write it as an image in a .net page, using the Response.BinaryWrite method. So, maybe it's not a commom image binary data. You can test this byte array saving as a file and try some extensions.

Regards, Leonardo Muzzi