PDA

View Full Version : changing a field type in mysql



eMEraLdwPn
02-06-2004, 08:12 PM
i have a field set as a "longblob" type in my database, but the problem with it is that i can't run incase-sensitive searches on it... so if i were to convert it to "text" type would that screw up the data? some of the data is rather large (5-10kb, maybe more) and does contain some html...

if i can't just change the field type to text, is there anything i could do to be able to run incase-sensitive searches?

Chris
02-06-2004, 09:51 PM
I don't think it would. Backup your DB and then try.

eMEraLdwPn
02-06-2004, 10:13 PM
yeah, i made a backup of the db and switched the fieldtype and everything seems fine =).. thanks