From: Reindl Harald Date: March 9 2012 12:43pm Subject: Re: A Blob That's a String?? List-Archive: http://lists.mysql.com/mysql/226948 Message-Id: <4F59FADF.20708@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig8147263CCE7676C85669AB5C" --------------enig8147263CCE7676C85669AB5C Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Am 09.03.2012 13:28, schrieb Jack Hatterly: > Even when I hard code in the correct values I get this error. However, = when I select * from pics, where there is only one longblob in the table,= it prints out a tremendous load of data which indicates to me that a bin= ary file has indeed been loaded. What I am trying to ascertain is why is = this longblob considered a string? How can I more properly test if a bina= ry file has been loaded? where is the difference of "binary" and "string" after fetch it from DB? the result IS a binary safe string! --------------enig8147263CCE7676C85669AB5C Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk9Z+t8ACgkQhmBjz394AnkE6QCfapKHNim/CoWofC2VM2mqpOyC kb8AnRDXDe++9OsgFMGZuOT33nYYSJY0 =r1i1 -----END PGP SIGNATURE----- --------------enig8147263CCE7676C85669AB5C--