On Mon, 18 Feb 2002 suresh(at)mithi(dot)com wrote:
> Hi
>
> I have a table with one of the fields as a varchar(32) field. This table has
> about 100,000 records.
> I want to increase the size of the varchar field to 64. How can this be done
> without affecting the data already present ?
Dump and restore after changing the field length is usually easiest, but
if you don't mind a little hacking in the system tables, check out the
archives and you'll find the particular recipe for doing it.