Data type conversion

Posted in 2006

YOO JAEDO — Mon, 16 Jan 2006 07:24:46 — source: IIUG Forums & Mailing Lists

Hi. Is it possible to modify data type from varchar to text with alter table command? I used command like "alter table table_name modify (column_name text...) but it didnt work at all. Please let me konw.. Thanks in advance..

↪ replying to YOO JAEDO

Andreas.KUTSCHE@spar.at — Tue, 17 Jan 2006 10:34:17 — source: IIUG Forums & Mailing Lists

Hi, what do You mean with >>didn't work at all<< ? Did You get an SQL error ? I don't know if the desired change is possible, but if yes: It is NOT an 'in-place-alter-table' , that means the whole table is copied into the new structure in one single statement/transaction : exclusive locking necessary, enough disk space to hold the table two times and risk of long transaction! Regards, Andreas Kutsche > ------------------------------------------- SPAR Oesterreichische Warenhandels-AG Hauptzentrale Europastrasse 3 A - 5015 Salzburg Tel: +43 662 4470 24223 Mobile: +43 664 6259575 E-Mail: Andreas.KUTSCHE@spar.at Internet: http://www.spar.at ------------------------------------------- -----Ursprüngliche Nachricht----- > Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Im Auftrag von > YOO JAEDO > Gesendet: Montag, 16. Jänner 2006 08:25 > An: ids@iiug.org > Betreff: Data type conversion [6214] > > > > Hi. > Is it possible to modify data type from varchar to text with > alter table > command? I used command like "alter table table_name modify > (column_name > text...) but it didnt work at all. > > Please let me konw.. Thanks in advance.. > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. > >