Re: genome sequence

[Thomas Spahni]

Hi Liz,

a column of type BLOB takes a maximum of 65535 bytes; try MEDIUMBLOB or
even LONGBLOB.

Regards, Thomas Spahni


On Tue, 20 Apr 2004 [EMAIL PROTECTED] wrote:

> hi,
>  I am trying to enter genome sequences of length 170 and more into
> mysql database.
>
> I have created a table sequence like:
>
> create table sequence(seq blob);
>
> i am using python scripts to put the sequence into this field.
> the python GUI gives me this error:
>
> OperationalError: (2006, 'MySQL server has gone away')
>
> I am not able to enter the sequence.
>
> what is wrong???
>
> Liz
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

genome sequence

[lga2]

hi, 
 I am trying to enter genome sequences of length 170 and more into 
mysql database.

I have created a table sequence like:

create table sequence(seq blob);

i am using python scripts to put the sequence into this field.
the python GUI gives me this error:

OperationalError: (2006, 'MySQL server has gone away')

I am not able to enter the sequence.

what is wrong???

Liz

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

genome sequence

[lga2]

hi
   I am trying to enter a genome sequence of length 170 in a table.

I have created the table as

create table sequence(Seq blob);

I am using Python script to enter this sequence into the table.

I am getting an error 

OperationalError: (2006, 'MySQL server has gone away')

I am not able to store this sequence into the table.

what is wrong???

Liz

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]