If you're connecting to the mySQL database through ODBC (why not just connect directly to mySQL server?) ... then you probably have to escape with a single quote. For most ODBC drivers you escape ' with '' (two single quotes) ..... took me a while to figure that one out, but works for me. :)
- Anthony "C C" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > I'm trying to insert binary data into a MS SQL Server > database. Text files are added fine, but binary files > with null bytes are not. The field I'm adding the > binary data to is image type. I get an error about > unclosed quotation marks at the null byte, but I've > replaced ' with ''. > > I tried escaping the null byte with a backslach, but > it just changes it to the string "\0" when I download > it. > > Anyone have any ideas about this? > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free web site building tool. Try it! > http://webhosting.yahoo.com/ps/sb/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
