MySql! Change Varchar to text

[Anon]

Hpw do u change varchar to text? im using phpmyadmin and it comes up with errors when i switch it with the drop down menu thing. I really need help. I tried manually typing it but it still dont work.. Look at my other message to see what i tried to do...

[Anon]

I develop php apps under Windows platform, and I use dos window to connect to mysql.

What you're asking can be accomplished with
ALTER TABLE table_name MODIFY column_name TEXT NOT NULL;

If you've tried that and it didn't work, then I don't have a clue what's wrong.

---

http://sabyo.dyns.cx/

[Anon]

ahahah it worked thanx man ur the coolest!