General discussion


Informix 255 to 4000

By cdrohlfing ·
What is the most painless way to handle changing a 255 varchar field to a 4000 varchar field?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Informix 255 to 4000

by rasjani In reply to Informix 255 to 4000

Im not familiar with informix at all but if you can have few minutes of offline time for that table then one of the easiest ways would be to dump that table to asciifile with drop/create tables and all. Then, edit the create table from 255 to 4000 and then reload the data back into db. This method is quite fast and basicly should keep table quite consistent. Ive used this method successfully on Ingres 6.(3-4) && Ingres II && PostgreSQL && MySQL.

Related Discussions

Related Forums