Results 1 to 3 of 3

Thread: changing a field type in mysql

  1. #1

    changing a field type in mysql

    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?

  2. #2
    Administrator Chris's Avatar
    Join Date
    Feb 2003
    Location
    East Lansing, MI USA
    Posts
    7,055
    I don't think it would. Backup your DB and then try.
    Chris Beasley - My Guide to Building a Successful Website[size=1]
    Content Sites: ABCDFGHIJKLMNOP|Forums: ABCD EF|Ecommerce: Swords Knives

  3. #3
    yeah, i made a backup of the db and switched the fieldtype and everything seems fine =).. thanks

Similar Threads

  1. MySQL driven AWS site
    By Best.Flash in forum User Owned Websites
    Replies: 9
    Last Post: 03-27-2004, 11:04 AM
  2. PHP - MySQL Portal software
    By manonthestreet in forum Website Programming & Databases
    Replies: 3
    Last Post: 10-27-2003, 01:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •