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: [EMAIL PROTECTED] From: Heikki Tuuri [EMAIL PROTECTED

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, I have an Access97 table containing binary fields (gifs) that I would like to migrate

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: Re: Cannot add blob data to innodb table Stephen, Hi, I have an Access97 table containing

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' character).

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 represent this by

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. After

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 would like to migrate to an innodb format via MyODBC (2.50.39