MIME-Version: 1.0
References: <CAEZv3co=t+YzkTmRMPR8Ev1izcb8VxYg-7jB2RCHSQGATsdHSg@mail.gmail.com>
 <CAEZv3copeUd7mNf98qxBtkqqW=g3MtCJe62jdMEEzFC4M=-+4A@mail.gmail.com>
 <CANzqJaDRQU2KsJt76TgPpES8qVg3i_sv5cZSmo=qoSN4VUzwNw@mail.gmail.com>
 <CAEZv3cqebrs+GT1YmWdk4sko7hgtstVKkcP+2OS07UtJ48x=dA@mail.gmail.com>
 <10fe353b-a5ba-4522-badf-89119179b4f0@ewie.name> <CAEZv3cqQ-LRPLM8iMsKh_Wc023pdHiW34AeuuY9jH-OF8FUnqg@mail.gmail.com>
 <9374c94f-95cc-4fa6-a997-a8fd7acdf379@aklaver.com> <CAEZv3cpMxZLUKV_Nm9qw-dBohuThC5co-5-p_OPD5Lnf8kxrgA@mail.gmail.com>
 <e7852df3-0724-494a-a555-2b4413c05ec7@aklaver.com>
In-Reply-To: <e7852df3-0724-494a-a555-2b4413c05ec7@aklaver.com>
From: Andy Hartman <hartman60home@gmail.com>
Date: Sat, 11 Jan 2025 19:09:44 -0500
Message-ID: <CAEZv3coWB7MYcoF807cQU4Ym2veuuZtBHEuUZzqa_kd7Pdedyg@mail.gmail.com>
Subject: Re: Display Bytea field
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Erik Wienhold <ewie@ewie.name>, Ron Johnson <ronljohnsonjr@gmail.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ce8e8e062b77258b"
Archived-At: <https://www.postgresql.org/message-id/CAEZv3coWB7MYcoF807cQU4Ym2veuuZtBHEuUZzqa_kd7Pdedyg%40mail.gmail.com>
Precedence: bulk

--000000000000ce8e8e062b77258b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

In mssql its a image datatype.

On Sat, Jan 11, 2025 at 7:08=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.com>
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@aklaver.com
>
>

--000000000000ce8e8e062b77258b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">In mssql its a image=C2=A0datatype.</div><br><div class=3D=
"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">O=
n Sat, Jan 11, 2025 at 7:08=E2=80=AFPM Adrian Klaver &lt;<a href=3D"mailto:=
adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&gt; wrote:<br></di=
v><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;borde=
r-left:1px solid rgb(204,204,204);padding-left:1ex">On 1/11/25 15:49, Andy =
Hartman wrote:<br>
&gt; I still have csv files and loaded right into PG no decoding and look <=
br>
&gt; like this little snippet and I did the COpy command into PG<br>
<br>
You have not answered:<br>
<br>
What data type was used to store data in MySQL?<br>
<br>
Show command used to pull data from MySQL.<br>
<br>
<br>
&gt; <br>
&gt; &quot;/9j/4AAQSkZJRgABAQAAAQABAAD<br>
<br>
Are you sure?<br>
<br>
The acceptable formats are shown here:<br>
<br>
<a href=3D"https://www.postgresql.org/docs/current/datatype-binary.html" re=
l=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/docs/current/=
datatype-binary.html</a><br>
<br>
And the above does not look like either.<br>
<br>
<br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
</blockquote></div>

--000000000000ce8e8e062b77258b--