如何在下载文件时修复奇怪的文件编码？

Question

I am trying to download a file from postgresql encoded in base 64. The content of the file seems to be good in the database bytea but it is not the same when I download it with PHP:

I am using PHP 5.6 with symfony 2.8. I've tried to decode in base 64 but with no success.

$name = $file->getName();
$content = base64_decode(stream_get_contents($file->getContent()));
$contentType = $file->getContentType();
$response = new Response();
$response->headers->set("Cache-Control", "no-cache private");
$response->headers->set("Content-Description", "File Transfer");
$response->headers->set('Content-Type', $contentType);
$response->headers->set('Content-Disposition', 'attachment; filename="' . $name . '"');
$response->headers->set("Content-Transfer-Encoding", "binary");
$response->headers->set('Content-Length: ', strlen($content));
$response->sendHeaders();
$response->setContent($content);
return $response;

For this example, I've created a file with notepad++ containing the string "test". In the database it is displayed like this "dGVzdA==".

When I download the file and I decode it, the content is this "Ǯ8kθطw", it should be "test".

Answer 1

PGSQL is converting my file into a hexadecimal value. It needed to be decoded. Moreover, there is a "/" at the beginning of the PQGSQL response. It needs to be removed.

Here is my treatment to the content:

$content = base64_decode(hex2bin(
    substr(
        stream_get_contents(
            $file->getContent()
        )
    ,1)
));