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