@john: "Dear all,
Using ODBC, the data from the mysql in Linux server are exacted to the Excel 
sheet in Windows XP.  It is found that most extracted data are normal but, 
only those of  medium-blob data type defined by the mysql  become random 
codes (with long digits). Why? Welcome for any of your help.
Regards,
John"
    @john: "Dear all,
The data originally belong to the characters of very large amount,  and 
therefore is set to be medium blob data-type, which can be normally viewed 
via. the webpage under the linux server installed with Apache webserver, 
mysql, and php compiler. Anyway, it can be viewed as binary code in Excel 
file   for which the data extracted through ODBC platform. Welcome for any 
of your further assistance.
Regards,
John
"Captain Paralytic" <email_address> 
???????:<email_address>
<quote>
blob fields are binary data (see 
<url>
The data could be a .jpg image, it could be a .exe executable, it
could be ...)
What you are seeing is the representation of the values of the bytes
held in that field.
How would you expect Excel to display an exe file in a cell? "
    @jstucklex: "<quote>
 > Dear all,
 >
 > The data originally belong to the characters of very large amount,
 > and therefore is set to be medium blob data-type, which can be
 > normally viewed via. the webpage under the linux server installed with
 > Apache webserver, mysql, and php compiler. Anyway, it can be viewed as
 > binary code in Excel file for which the data extracted through ODBC
 > platform. Welcome for any of your further assistance.
 >
 > Regards,
 > John
 >
(Top posting fixed)
Paul (Captain Paralytic) gave you the answer to your question.  Is there 
something you don't understand about his post?
P.S. Please don't top post.  Thanks.
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
<email_address>
=================="
{'source': 'USENET', 'other_information': '{"reply_count": 2, "forum_name": "comp.databases.mysql.20150604.mbox"}', 'file': 'data/output/usenet-comp.databases.parquet'}