Strange Characters

sanci's profile image sanci posted 3 years ago in General Permalink

Hello

When I view my database in HeidiSQL, some of the data appears to be corrupt (strange characters), although when I view it in phpMyAdmin, it appears as it should

phpMyAdmin - snipboard.io/zyefOR.jpg

HeidiSQL - snipboard.io/1ylm7K.jpg

Wondering if you know why this might be happening?

Thank you

ansgar's profile image ansgar posted 3 years ago Permalink

The difference is just the text formatting. pma shows it as hex code, which you seem to have switched off in HeidiSQL.

See the data section in the help file for how to show blobs as hex.

sanci's profile image sanci posted 3 years ago Permalink

Thank you!

Please login to leave a reply, or register at first.