Answer the question
In order to leave comments, you need to log in
How to convert MySQL binary type with its values to PgSQL?
The question is about the MySQL binary type and its values for correct conversion to PgSQL.
There are MySQL code options:
1:
CREATE TABLE "table" ( "field" binary(1) );
INSERT INTO "table" VALUES ('1', '5', '3');
CREATE TABLE "table2" ( "field" binary(1) );
INSERT INTO "table2" VALUES ('A', 'F', 'C');
CREATE TABLE "table3" ( "field" binary(32) );
INSERT INTO "table3" VALUES ('\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0^A '),('\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0^B ')
Answer the question
In order to leave comments, you need to log in
See Data Types in PostgreSQL
in PostgreSQL is bytea data type - Binary Data Types
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question