MySQL Forums
Forum List  »  Newbie

Re: How can i Extract LongText Images
Posted by: Peter Brawley
Date: February 07, 2019 07:37PM

MySQL text columns are strings encoded in a particular character set with a particular collation. To retrieve them you'll need to know their charset & collation. Start by executing the cmd Show Create Table on he table. That will tell you what charset & collation to use retrieving the column values.

If the strings represent images, you'll also need to know what sort of images they are---bmp, jpg, png, whatever.

Options: ReplyQuote


Subject
Written By
Posted
Re: How can i Extract LongText Images
February 07, 2019 07:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.