knipper Posted April 30, 2003 Share Posted April 30, 2003 Hey Guru's... I need to lengthen the length of the products_url field that resides in the products_description table. Currently it is a varchar(255), however I need more available space. What would you suggest I modify the type to? Longtext, text, etc. What allows more than 255 characters....Blob? Thanks in advance! :D Steve K AKA - Knipper - Link to comment Share on other sites More sharing options...
Guest Posted April 30, 2003 Share Posted April 30, 2003 http://www.mysql.com/doc/en/BLOB.html Link to comment Share on other sites More sharing options...
knipper Posted April 30, 2003 Author Share Posted April 30, 2003 Thanks for that... But I wanted to make sure it OK to actually change the table field, and it won't cause osC to have bad effects. Looks like I'll go with text. But a bump from 255 characters to 65535 is pretty big! Steve K AKA - Knipper - Link to comment Share on other sites More sharing options...
Ian Posted April 30, 2003 Share Posted April 30, 2003 There should be no problems changing the field type. BTW you can set a length for a text type :D Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.