changing varchar count
PowerStore> users table.
Client wants to limit the number of characters in a company name, etc. It is currently set to varcher(100). He wants it set to 35. So far so good. However, since the cart has been active for a couple of years, there are some companies with longer than 35 characters, so phpMyAdmin is not allowing the change. Is there a way to force the change? Alternately, is there a way to search in the cart admin for longer names? I didn't see a way yet.
One way maybe for me to set up a page that reflects all the companies in a list, associated with the ID, then change directly in the db.
Any other ideas, most appreciated.