Datatype for MySQL Varbinary - Mailing list pgsql-novice

From Bill P.
Subject Datatype for MySQL Varbinary
Date
Msg-id 803738.38654.qm@web65815.mail.ac4.yahoo.com
Whole thread Raw
Responses Re: Datatype for MySQL Varbinary  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-novice
Hello,

I am in the process of migrating a mysql db to a postgresql one and there are a few tables with columns with datatypes of 'Varbinary'
These columns store the AES_ENCRYPTed output of a value.

What datatype should I set the postgresql table.column to for this to be stored properly? 

I cannot decrypt the data and re-encrypt it into postgres, so the format and content need to remain the same on migration.

Thank you.


pgsql-novice by date:

Previous
From: Machiel Richards
Date:
Subject: pgstatspack version?
Next
From: Kenneth Marshall
Date:
Subject: Re: Datatype for MySQL Varbinary