Re: Loading BLOB into a MySQL-DB

2002-05-29 Thread D.K.Dubey
Hi Chris, See the code how load BLOB into a MySQl String saveSql = "INSERT INTO Table (DataCol) VALUES (?)" try { bos = new ByteArrayOutputStream(); oos = new ObjectOutputStream(new BufferedOutputStream(bos)); fileObj.writeObjectData(oos); oos.

RE: Loading BLOB into a MySQL-DB

2002-05-29 Thread Dean Harding
Christian, It's pretty easy, you can do it with a normal INSERT statement, all you've got to remember is that NUL (ascii 0) needs to be escaped as "\0", and that double quotes and single quotes should also be escaped (i.e. \" and \'). Getting the data back again is even easier, because it'll une