Answering my own question:

In MySQL: attachments are stored in binary format into blob field

In Postgres: attachments are stored as base64 encoded into text field.

Atenciosamente,

Edson Richter

Soli Deo Gloria

De: otrs <otrs-bounces@lists.otrs.org> Em nome de Edson Richter
Enviada em: quinta-feira, 21 de fevereiro de 2019 12:40
Para: User questions and discussions about OTRS. <otrs@lists.otrs.org>
Assunto: [otrs] Are FAQ attachments stored differently in MySQL and PostgreSQL?

Hi!

Are FAQ attachments stored differently in MySQL and PostgreSQL?

I ask that because in MySQL I do have a “BLOB” type for the “content” column, and in PostgreSQL a “TEXT” type.

I’ll appreciate your directions.

Regards,

Edson Richter

Soli Deo Gloria