I have mistakenly inserted a variable 18-20 digit variable into an unsigned INT() column.

The data has been truncated to the max 32bit length so all my data is displayed as "4294967295"

Is there any way to retrieve the original data?

  • is binlog or general log enabled by any chance? – akuzminsky Oct 30 '14 at 14:52
  • unfortunately not, that was my first go to.. – brndnmg Oct 30 '14 at 21:57

The basic answer is: No.

Do you have a record of the 18-20 digit value somewhere? In another location in your database, on a piece of paper on you desk, etc? If so then use the source information to correct your error.

You have not indicated which database software you are using, which can make a difference for many issues.

| improve this answer | |
  • Apologies, major oversight, MySQL / Percona, the data came from customer submissions, unfortunately – brndnmg Oct 30 '14 at 13:17
  • If you know the customer, I would suggest going back to them and asking for a re-submission. – RLF Oct 30 '14 at 13:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.