Re: Re:ERROR 1073: create InnoDB tables!

[camelon takanabe]

Hi, Heikki.

Thanks for the info. 

I understand your first explanation, I'll try.

 You can probably circumvent the problem by
 adding an extra VARCHAR column where you put
 the first 255 characters of the blob column.

Would you please inform me more externation of second.
Can you give me an examples?

 Or maybe you could generate an artificial
 primary key with auto-increment, for example?

-- 
Best regards.


- Original Message - 
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 13, 2001 12:50 AM
Subject: Re:ERROR 1073: create InnoDB tables!


 Hi!
 
 You can probably circumvent the problem by
 adding an extra VARCHAR column where you put
 the first 255 characters of the blob column.
 Or maybe you could generate an artificial
 primary key with auto-increment, for example?
 
 Regards,
 
 Heikki
 http://www.innodb.com
 
 Hi,
 I tried create table specify type=InnoDB.with the following script:
create table objects(uri blob not null, primary key uriIndex (uri(255)),
  classname blob) type=InnoDB;I'm getting the following error
ERROR 1073: BLOB column 'uri' can't be used in key specification with
 the used \
 table typeThis is what I found in the mySQL docs:
 * Only the MyISAM table type supports indexing on BLOB and TEXT columns.
 When putting \
 an index on a BLOB or TEXT column you MUST always specify the length of the
 index:
  CREATE TABLE test (blob_col BLOB, index(blob_col(10)));
 I could change the uri to varchar but...
 * Values in VARCHAR columns are variable-length strings. I can declare a
 VARCHAR \
 column to be any length between 1 and 255, just as for CHAR columns.
 That's not very good, we can choose- transactions but uri limited to 255 chars
 - no limit but also no transactions
 Is it supported ? If yes, please let me know how?Any help is welcome.
 



-
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

ERROR 1073: create InnoDB tables!

[camelon takanabe]

Hi,

I tried create table specify type=InnoDB.
with the following script:

   create table objects(uri blob not null, primary key uriIndex (uri(255)),
 classname blob) type=InnoDB;

I'm getting the following error

   ERROR 1073: BLOB column 'uri' can't be used in key specification with the used 
table type

This is what I found in the mySQL docs:
* Only the MyISAM table type supports indexing on BLOB and TEXT columns. When putting 
an index on a BLOB or TEXT column you MUST
always specify the length of the index:
 CREATE TABLE test (blob_col BLOB, index(blob_col(10)));

I could change the uri to varchar but...
* Values in VARCHAR columns are variable-length strings. I can declare a VARCHAR 
column to be any length between 1 and 255,
just as for CHAR columns.

That's not very good, we can choose
- transactions but uri limited to 255 chars
- no limit but also no transactions

Is it supported ? If yes, please let me know how?
Any help is welcome.



-
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