If you are unsure you should make a copy of the table and perform you test actions on that table. The answer is yes you can convert your unsigned integer column to a varchar column.
On Mon, 05 Apr 2004, joe collins wrote: > > I have a table that has a column : > session_id INTEGER UNSIGNED NOT NULL, > > I now want to store a hexadecimal value in this column instead. > > the column already contains values for some records.....can I alter the data > type of this column (make it a varchar) without loosing the data already > stored? > > or must I drop the column and then add it using the new data type. > > I would loose my data by dropping the column. > > (I can extract the data and repopulate the table (with the new data type > field) if necessary but would like to avoid this) > > > any ideas? > > Regards > > Joe > > > ---------------------------------------- Content-Type: text/plain; name="unnamed" Content-Transfer-Encoding: 7bit Content-Description: ---------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]