> 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. Yep, first make a backup copy of your table, then alter the column to varchar type. To convert the existing decimal data to hexadecimal format you could do a UPDATE table SET column = HEX(column); (MySQL >= 4.0.1)
Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
