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]> > >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) 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 5 or so minutes, the > >>append query in Access97 quits and an ODBC error window complaining about a > >>lost connection pops-up. When I convert the table to myisam type, the append > >>query works. Is there something in my.cnf I need to adjust to fix thisproblem? > > > >inserting binary BLOBs should work. What is an 'append' query in MS Access? > Is it translated to an INSERT in MySQL? Could you paste a copy of what the > MySQL query logs shows? > > > >How big is the BLOB? What is the CREATE TABLE statement? Note that a BLOB > bigger than > 64 kB needs to be defined a MEDIUMBLOB or LONGBLOB in the > CREATE TABLE statement. > > > >If you try inserting an ASCII text file does that work? > > > >How big you have set > > > >max_allowed_packet > > > >in my.cnf? That restricts the size of rows communicated from a client to > the server. > > > >>Thanks, > >>Stephen > > > >Regards, > > > >Heikki > >http://www.innodb.com > > actually, are you running MySQL on Windows? Then the problem might be the > bug introduced in 3.23.42: to access InnoDB tables you must use the same > case of letters in the database name as you used in the CREATE TABLE > statement. Make sure you consistently use lower case in database names. The > bug is fixed in upcoming 3.23.45. Please don't fix this. Case insensitivity means that you can't use windows to test something which will run under Unix where CASE COUNTS. Case insensitivity in table names is one of the more annoying Gatesisms that limit the usability of windows for testing.
> > Does mysql.err contain anything? > > Regards, > > Heikki > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
