Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Changing the Column Type

Quote Reply
Changing the Column Type
Heya all,

What will happen if I change the Column Type of a record from VARCHAR to INT and resync the database? Will I loose all data? Will I only loose data that's not of type "INT" (i.e. numbers) or will I loose nothing?

Safe swoops
Sangiro
Quote Reply
Re: [sangiro] Changing the Column Type In reply to
Hi,

Yes, MySQL will try and convert the values to numbers. Always best to do a mysqldump before hand just in case though.

Cheers,

Alex
--
Gossamer Threads Inc.