"Escape" file string externally loaded

Question

Problem:

I am trying to pass to the database a String containing the bytes of an image that was externally loaded to place in a BLOB field. As always, the bytes of the image have single quotes ', double quotes " and backslash \. Turns out the backslash is a metacharacter and the quotes are delimiters of a literal string, and that’s where the problems arise. See the example bytes:

"Íäwóužü'vaõyt¾’m&²2\

When loading these bytes into String, I need them to stay "escapades", thus:

\"Íäwóužü'vaõyt¾ ’m&²2\\

If I try to carry them inside the object ByteArray of Flash, bytes are recognized normally, but for communication with the database, it is necessary that they are in the format of String.

Below an example in the code:

var loader:Loader = new Loader();
loader.load(new URLRequest("URL_DA_IMAGEM"));
loader.contentLoaderInfo.addEventListener(Event.COMPLETE, function(e:Event):void {

    var string:String = loader.content.loaderInfo.bytes.toString();
    var query:String = "INSERT INTO tabela (arquivo) VALUES (' "+string+" ')";
    var bytearray:ByteArray = loader.content.loaderInfo.bytes;

    trace(loader.content.loaderInfo.bytes); //"ÍäWÓužü’vaŽyt¾'m&²2\ - VALOR CORRETO, PORÉM NÃO ESCAPADOS
    trace(string); //"ÍäWÓužü’vaŽyt¾'m&²2\ - VALOR CORRETO, PORÉM NÃO ESCAPADOS
    trace(query); /*Erro pois a string com as aspas simples/aspas duplas não está escapada, 
    logo a query dá erro de syntax: INSERT INTO tabela (arquivo) VALUES (' "ÍäWÓužü’vaŽyt¾'m&²2\ ')
    */

}

Attempts:

1. Use String query passing as parameter the ByteArray. But I got error, because Bytearray is not String.
2. Method replace with Regexp does not work: string.replace(/(\')/g, "\'"); because Flash automatically removes the backslash, and does not keep it.

Question:

Someone has a solution?

Answer 1

A byte array is not a string and should not be treated as such.

They are just bytes, which happen to become a character with an accent by mere chance. If you remove the accent, you will change the format of the bytes, and consequently your file.

I don’t know Actionscript, but from what I’ve seen it must be something like this:

var query:SqlStatement = new SqlStatement();
query.text = "INSERT INTO tabela (arquivo) VALUES (:byteArray)";

query.parameters[":byteArray"] = loader.content.loaderInfo.bytes;