I'm working on an SQL database via PHPmyAdmin and i have a column called pagesText, it supposed to show some text but all i see is "[BLOB - ...]".
what is this? and how can i get the original text?
Asked
Active
Viewed 5,244 times
0
-
1Check this http://googleitfor.me/?q=blob+mysql – swapnesh Aug 31 '13 at 12:09
-
It says BLOB because PHPMyAdmin doesn't want to display 6.4KiB of text in that tiny space... – Michael Berkowski Aug 31 '13 at 12:14
-
1No , it says "BLOB" instead of showing any content because it could *possibly* contain non-printable bytes. That's what "BLOB" means: "*b*inary *l*arge *ob*ject". – bart Aug 31 '13 at 12:23
3 Answers
0
About Blob:
From Wikipedia:
http://en.wikipedia.org/wiki/Binary_large_object
A blob (alternately known as a binary large object, basic large object, BLOB, or BLOb) is a collection of binary data stored as a single entity in a database management system. Blobs are typically images, audio or other multimedia objects, though sometimes binary executable code is stored as a blob. Database support for blobs is not universal.
Basically what it means is that your data is saved in binary format directly. (all data is binary, I know.)
But, you can simply access the field via your code in PHP and can manipulate, echo it easily.
PhpMyAdmin shows it as BLOB here, since it does not want to show long texts in record tables.
Sunny R Gupta
- 5,026
- 1
- 31
- 40
0
Your text has been stored as binary data, see wikipedia http://en.wikipedia.org/wiki/Binary_large_object
Read also phpmyadmin shows numbers or blob for mysql's utf8_bin callation columns?
