I have a mysql database that has feedback from users:
id, comment, name, company
the id is an int, the comment is a blob, name and company are varchars.
I basically went through the database using CocoaMySQL on OS X and changed all the values for company.
Having exited the database and went to the website to check the changes all the comment fields have turned to numbers and letters (I’m presuming some kind of hex or ASCII values) is there any way to get this back as its lots of data that is no longer viewable and there isn’t much hope of getting it back.
Here’s an example:
Your help would be very much appreciated thank you as this has put me in a really awkward situation.