Convert Int Field to Text?

slevytam

Hello,

Just a quick question. I need to convert a primary key, not null, integer field to a primary key, not null, text field. I am getting this error...

ERROR 1170: BLOB column 'fid' used in key specification without a key length

Thank you,

Shalom

drawmack

try making it a text field instead of a blob field

tomhath

Post the code. I don;t know what it means to "convert" a column

slevytam

Ok,

If it was any other key but the primary key then this would work. What I am look for is a way to do this on the primary key.

alter table geninfo
change fid fid text;

Thanks,

Shalom

AshtrayWaterloo

Just a quick note: text type fields (ie. text, longtext, etc.) cannot be primary keys on a table.

Ash

slevytam

would it then be okay to have a table with no primary key or is that really bad form?

Thanks,

AshtrayWaterloo

It's perfectly all right. The only thing you need to watch out for are completely duplicated rows. They can be a pain, but it won't stop the tables from working.

Ash