Decode mail_text field when using postgres

[Giuseppe De Nicolo']

On 01/26/2015 09:58 PM, Antoine Nguyen wrote:
>
> On 26/01/2015 18:06, Giuseppe De Nicolo' wrote:
>> On 01/23/2015 10:44 AM, Antoine Nguyen wrote:
>>> Hi all,
>>>
>>> I'm using postgres and I'm encoutering issues when I try to decode 
>>> the mail_text field of a 'quarantine' table record (to display it in 
>>> my quarantine manager).
>>>
>>> Since the type of this field is "bytea", its value is encoded so I 
>>> can't check what charset is used before trying to decode it with a 
>>> "convert_from" call.
>>>
>>> Does someone know what is the recommended way to do this? Mark?
>>>
>>> Thanks in advance,
>>> Antoine Nguyen
>>> http://modoboa.org/
>>>
>>
>> Hi
>> what is the value of
>>
>> $sql_allow_8bit_address in amavisd.conf ?
>>
> The value is 1.
>
>
Are you using MailZu by chance ?