0

A year ago we had a problem with our database at we had to re-upload it. We have since discovered that symbols like " og ' have been converted to square symbols as shown on the image. enter image description here

It is only shown in the browser - when we look in the database directly it just appears as an extra space.

Is there anyway to find all rows in a database where it appears?

I have tried to look around but without any results unfortunately. Looking at ASCII, REGEX etc.

The tables data is: Type: InnoDB Encoding: UTF-8 Unicode (utf8) Collation: utf8_general_ci

Thanks in advance!

Jonathan Parisi
  • 23
  • 5
  • I susect they are not the ascii " or ', but some slanted quotes or apostrophes. Get the hex of the source; that will help in further identifying the problem. For comparison, also get hex of the a-hat. – Rick James Dec 02 '22 at 23:48

0 Answers0