Linux

Ask something
Discussion Locked

Informix 255 to 4000

0 helpful
1 reply

by cdrohlfing 4 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
What is the most painless way to handle changing a 255 varchar field to a 4000 varchar field?

1 reply

by rasjani

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.

This discussion is closed to new replies.