Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Strange Characters

kodame's profile image kodame posted 5 months 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 5 months 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.

kodame's profile image kodame posted 5 months ago Permalink

Thank you!

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.