Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › changing varchar count

View all replies to this thread

changing varchar count

Thread began 4/02/2019 11:25 am by Patrice | Last modified 4/03/2019 9:12 am by Patrice | 758 views | 4 replies

4/02/2019 11:25 amPatriceWebAssist

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.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.