Unix Technical Forum

mysql client command \G and blob fields

This is a discussion on mysql client command \G and blob fields within the MySQL General forum forums, part of the MySQL category; --> I've been experimenting with storing image data in blob fields, and I was surprised that using the mysql client ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 07:02 AM
dpgirago@mdanderson.org
 
Posts: n/a
Default mysql client command \G and blob fields

I've been experimenting with storing image data in blob fields, and I was
surprised that using the mysql client to select the field with a
semi-colon query terminator resulted in the binary data being dumped to
the terminal (with lots of beeping) while using the \G query terminator
resulted in just a few symbols such as

imgdata: ëPNG
?
(where imgdata is the field name) and no beeps.

I'm _not_ surprised with the beeps due to trying to view the binary data,
just the disparity in behavior when using the different terminators.

I've been searching the manual for about an hour now and can't seem to
find a reference to this difference in behavior in the mysql client.

Nothing urgent here. Just wondering if anyone can shed some light on this
as I've always gotten the same results either way, though I'm certainly no
expert using blob data types.

Thanks,

David
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:16 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com