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-boun...@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

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

Reply via email to