MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jan Schneider Date:March 3 2000 10:07am
Subject:RE: Problems inserting escaped binaries
View as plain text  

> > I've got some problems inserting binary data into blob fields.
> The data is
> > correctly escaped ( \0, \", \', \\ ) and no matter if I'm using
> a script API
> > (PHP) or the MySQL client: Inserting stops at the first escaped
> character.
> How are you escaping the binary fields?  Are you using
> mysql_escape_string(),
> or are you doing it yourself?  Could you post the relevent piece of code?

In PHP I use addslashes() which escapes quotes, nuls and backslashes as
shown above.

Bye, Jan!

Problems inserting escaped binariesJan Schneider3 Mar
Re: Problems inserting escaped binariesEd Carp3 Mar
  • RE: Problems inserting escaped binariesJan Schneider3 Mar