Обсуждение: Datatype for MySQL Varbinary
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.
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.
On Tue, Dec 14, 2010 at 01:25:16PM -0800, Bill P. wrote: > 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. > BYTEA: http://www.postgresql.org/docs/9.0/static/datatype-binary.html Cheers, Ken