• Registered: 2006-02-19
  • Posts: 14

Topic: Blobs :S

Hey GMan, just wonder wink i know its cheeky but i'm kinda desperate, in the mysql u have ways of getting int val's double, long etc, but no way of getting blob data? is this something u could impletement?

a blob is a binary object (i.e used for storing images) and shouldnnt be too hard for u to do

well thanks

  • gman
  • Administrator
  • Offline
  • Registered: 2006-01-04
  • Posts: 764

Re: Blobs :S

will try to look into this tonight.

  • Registered: 2006-02-19
  • Posts: 14

Re: Blobs :S

thanks dude, it'll save me having to use PHP or ftp smile

  • gman
  • Administrator
  • Offline
  • Registered: 2006-01-04
  • Posts: 764

Re: Blobs :S

k.  try this...  there is already a method called escapeString().  you need to pass in your binary info to this before you add it into your SQL statement.  this should safely escape any characters that would cause your query to break.  then simply build your SQL statement to include the escaped blob data and execute.

  • Registered: 2006-02-19
  • Posts: 14

Re: Blobs :S

so do as a string?

  • gman
  • Administrator
  • Offline
  • Registered: 2006-01-04
  • Posts: 764

Re: Blobs :S

yes try it as a string wrapped in single quotes.  before you add it into your SQL, do the escapeString method on it.