Re: Cannot add blob data to innodb table

2001-11-13 Thread William R. Mussatto
On Mon, 12 Nov 2001, Heikki Tuuri wrote: > Date: Mon, 12 Nov 2001 09:06:42 +0200 > From: Heikki Tuuri <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: Cannot add blob data to innodb table > > Steve, > > >Date: Mon, 12 Nov 2001 08:52:54 > >To:

Re: Cannot add blob data to innodb table

2001-11-12 Thread Heikki Tuuri
Hi! At 08:57 AM 11/12/01 -0800, you wrote: >> >> how do you communicate the binary strings to MySQL? From the manual I >> found: >> >> " >> If you want to insert binary data into a BLOB column, the following >> characters must be represented by escape sequences: >> >> NUL >> ASCII 0. You should r

Re: Cannot add blob data to innodb table

2001-11-12 Thread Stephen Lee
> > how do you communicate the binary strings to MySQL? From the manual I > found: > > " > If you want to insert binary data into a BLOB column, the following > characters must be represented by escape sequences: > > NUL > ASCII 0. You should represent this by `\0' (a backslash and an ASCII > `0'

Re: Cannot add blob data to innodb table

2001-11-12 Thread Heikki Tuuri
Stephen, At 12:53 AM 11/12/01 -0800, you wrote: >Hi Heikki, > >Comments inserted in text below: > >> Steve, >> >>>Date: Mon, 12 Nov 2001 08:52:54 >>>To: [EMAIL PROTECTED] >>>From: Heikki Tuuri <[EMAIL PROTECTED]> >>>Subject: R

Re: Cannot add blob data to innodb table

2001-11-12 Thread Stephen Lee
Hi Heikki, Comments inserted in text below: > Steve, > >>Date: Mon, 12 Nov 2001 08:52:54 >>To: [EMAIL PROTECTED] >>From: Heikki Tuuri <[EMAIL PROTECTED]> >>Subject: Re: Cannot add blob data to innodb table >> >>Stephen, >> >>>Hi,

Re: Cannot add blob data to innodb table

2001-11-11 Thread Heikki Tuuri
Steve, >Date: Mon, 12 Nov 2001 08:52:54 >To: [EMAIL PROTECTED] >From: Heikki Tuuri <[EMAIL PROTECTED]> >Subject: Re: Cannot add blob data to innodb table > >Stephen, > >>Hi, >> >>I have an Access97 table containing binary fields (gifs) that I wo

Re: Cannot add blob data to innodb table

2001-11-11 Thread Heikki Tuuri
Stephen, >Hi, > >I have an Access97 table containing binary fields (gifs) that I would like >to migrate to an innodb format via MyODBC (2.50.39) and MySQL-Max (3.23.44). >The MySQL query log shows binary-like characters being received but there >never seems to be progression to the next record. A