In mssql its a image datatype.
On Sat, Jan 11, 2025 at 7:08 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 1/11/25 15:49, Andy Hartman wrote:
> I still have csv files and loaded right into PG no decoding and look
> like this little snippet and I did the COpy command into PG
You have not answered:
What data type was used to store data in MySQL?
Show command used to pull data from MySQL.
>
> "/9j/4AAQSkZJRgABAQAAAQABAAD
Are you sure?
The acceptable formats are shown here:
https://www.postgresql.org/docs/current/datatype-binary.html
And the above does not look like either.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx