List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 21 2000 5:17pm
Subject:Re: HELP, PLS: TEXT (BLOB) fields!
View as plain text  
At 5:18 PM +0300 2000-06-21, Vitaly Yermolenko wrote:
>Hello!
>
>I am terrible sorry again, but ...

MYISAM table types appeared in MySQL 3.23.  You can't use them
with MySQL 3.22.34.

Also, you can't index TEXT or BLOB column types until MySQL 3.23.


>----- Original Message -----
>From: Carsten H. Pedersen <carsten.pedersen@stripped>
>To: Vitaly Yermolenko <vyermolenko@stripped>;
><mysql@stripped>
>Sent: Tuesday, June 20, 2000 1:53 PM
>Subject: RE: HELP, PLS: TEXT (BLOB) fields!
>
>
>>  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 am trying the next command and get the next result:
>
>mysql> CREATE TABLE test (
>     -> ID int not null auto_increment,
>     -> primary key (ID),
>     -> text_col text not null,
>     -> index(text_col(10))) TYPE = MYISAM;
>ERROR 1073: BLOB column 'text_col' can't be used in key specification with
>the used table type
>mysql>
>
>I use MySQL version - 3.22.34.
>
>How to create table with TEXT fields? Any help is welcome... Thanks!
>
>Regards,
>Vitaly.
>
>
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/php/manual.php3" before
>posting. To request this thread, e-mail mysql-thread41116@stripped
>
>To unsubscribe, send a message to:
>     <mysql-unsubscribe-paul=snake.net@stripped>


-- 
Paul DuBois, paul@stripped
Thread
HELP, PLS: TEXT (BLOB) fields!Vitaly Yermolenko20 Jun
  • RE: HELP, PLS: TEXT (BLOB) fields!Carsten H. Pedersen20 Jun
    • Re: HELP, PLS: TEXT (BLOB) fields!Vitaly Yermolenko21 Jun
      • Re: HELP, PLS: TEXT (BLOB) fields!Paul DuBois21 Jun
  • Re: HELP, PLS: TEXT (BLOB) fields!sinisa20 Jun