Re: Display Bytea field

On 1/11/25 16:09, Andy Hartman wrote: In mssql its a image datatype. Oops, I was referring to the wrong database(MySQL) in previous posts. So: Show command used to pull data from MS SQL Server. On Sat, Jan 11, 2025 at 7:08 PM Adrian Klaver > wrote: O

Re: Display Bytea field

In mssql its a image datatype. On Sat, Jan 11, 2025 at 7:08 PM Adrian Klaver 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

Re: Display Bytea field

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/4AA

Re: Display Bytea field

I bet Image*Source* doesn't contain what you think it does. I'd query that table using SSMS, to see what's really in that column. On Sat, Jan 11, 2025 at 6:49 PM 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 C

Re: Display Bytea field

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 "/9j/4AAQSkZJRgABAQAAAQABAAD On Sat, Jan 11, 2025 at 11:50 AM Adrian Klaver wrote: > On 1/11/25 03:05, Andy Hartman wrote: > > I used PS to pull the data from mssql

Re: Display Bytea field

On 1/11/25 03:05, Andy Hartman wrote: I used PS to pull the data from mssql  to Postgres dumping data to csv. I then used csv to load Postgres and the table that has Bytea What data type was used to store data in MySQL? Show command used to pull data from MySQL. # Convert the image data to

Re: Display Bytea field

1. Do you still have the CSV file (or can you regenerate it from the still-existing MSSQL DB)? 2. Did you load the base64 string into PG, or did you decode before loading into PG? 3. A base64 string would be about 62KB. Either you did something wrong when loading, or the programmer is doing someth

Re: Display Bytea field

I used PS to pull the data from mssql to Postgres dumping data to csv. I then used csv to load Postgres and the table that has Bytea # Convert the image data to a base64 string -- powershell $base64Image = [Convert]::ToBase64String($row.ImageSource) AFter data was loaded the developer said