Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to change the data type for one of my mysql database table column from bigint(20) to something like varchar(X), I'm not use what the X value should be. Please note that the column contains more than 2000 entries with very sensitive data.

Now, the situation has been changed and we also need to include non-digit characters along with the other numerical values. But, the problem is, because of the bigint datatype, we're not able to use non-digit characters for that perticular column value.

We know that if we change the datatype to varchar then this issue will be fixed. But, what we don't know is that if we change the data type from bigint to varchar, will any data be lost in the process ?

Could anybody put some thoughts on this matter?

share|improve this question
1  
What have you tried? Have you observed any data loss? –  Sebastian Meine Jan 23 at 16:09
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.