troubleshooting Question

PHP: Get text content scrambled by UTF-8

Avatar of hankknight
hankknightFlag for Canada asked on
PHPMySQL Server
5 Comments1 Solution979 ViewsLast Modified:
Somehow the data in a MySQL database ended up in a format that looks like this.

Using PHP, is there any way I can get the actual text from this?

I tried using mb_convert_encoding() and I also tried using utf8_decode() but I cannot figure out how to get actual text content from this:

"0S"0h"0o"0r"0t"0l"0i"0s"0t"0e"0d"0 "0f"0o"0r"0 "0t"0h"0e"0 "02"00"01"01"0 "0F"0r"0a"0n"0k"0 "0O "0C"0o"0n"0n"0o"0r"0 "0S"0h"0o"0r"0t"0 "0S"0t"0o"0r"0y"0 "0A"0w"0a"0r"0d"0,"0 "0t"0h"0e"0 "0w"0o"0r"0l"0d"0'"0s"0 "0r"0i"0c"0h"0e"0s"0t"0 "0s"0h"0o"0r"0t"0 "0s"0t"0o"0r"0y"0 "0p"0r"0i"0z"0e"0 "0 "0 "0 "0""0T"0r"0a"0f"0f"0o"0r"0d"0'"0s"0 "0a"0l"0c"0h"0e"0m"0i"0c"0a"0l"0 "0m"0i"0x"0i"0n"0g"0 "0o"0f"0 "0r"0e"0s"0e"0a"0r"0c"0h"0,"0 "0f"0a"0b"0l"0e"0,"0 "0p"0a"0t"0h"0o"0s"0,"0 "0a"0n"0d"0 "0p"0l"0o"0t"0 "0y"0i"0e"0l"0d"0s"0 "0i"0m"0p"0r"0e"0s"0s"0i"0v"0e"0 "0r"0e"0s"0u"0l"0t"0s"0."0""0-"0R"0a"0i"0n"0 "0T"0a"0x"0i"0 "0 "0 "0 "0""0I"0 "0l"0o"0v"0e"0 "0M"0a"0t"0h"0e"0w"0 "0J"0."0 "0T"0r"0a"0f"0f"0o"0r"0d"0'"0s"0 "0i"0m"0a"0g"0i"0n"0a"0t"0i"0o"0n"0!"0 "0I"0n"0 "0h"0i"0s"0 "0w"0o"0r"0l"0d"0,"0 "0s"0c"0i"0e"0n"0t"0i"0s"0t"0s"0 "0c"0l"0o"0n"0e"0 "0J"0e"0s"0u"0s"0 "0C"0h"0r"0i"0s"0t"0,"0 "0f"0i"0s"0h"0e"0r"0m"0e"0n"0 "0h"0a"0u"0l"0 "0m"0e"0r"0m"0a"0i"0d"0s"0 "0f"0r"0o"0m"0 "0t"0h"0e"0 "0s"0e"0a"0,"0 "0a"0n"0d"0 "0b"0a"0r"0t"0e"0n"0d"0e"0r"0s"0 "0s"0p"0r"0o"0u"0t"0 "0a"0n"0g"0e"0l"0 "0w"0i"0n"0g"0s"0."0 "0T"0h"0e"0 "0D"0i"0v"0i"0n"0i"0t"0y"0 "0G"0e"0n"0e"0 "0i"0s"0 "0a"0 "0f"0a"0n"0t"0a"0s"0t"0i"0c"0a"0l"0 "0r"0i"0d"0e"0 "0a"0n"0d"0 "0a"0 "0f"0a"0n"0t"0a"0s"0t"0i"0c"0 "0r"0e"0a"0d"0."0""0 "0-"0 "0N"0e"0i"0l"0 "0S"0m"0i"0t"0h"0,"0 "0a"0u"0t"0h"0o"0r"0 "0o"0f"0 "0B"0a"0n"0g"0 "0C"0r"0u"0n"0c"0h"0 "0 "0 "0 "0""0I"0n"0 "0t"0h"0e"0s"0e"0 "0u"0n"0i"0q"0u"0e"0 "0a"0n"0d"0 "0w"0i"0l"0d"0l"0y"0 "0i"0m"0a"0g"0i"0n"0a"0t"0i"0v"0e"0 "0s"0t"0o"0r"0i"0e"0s"0,"0 "0M"0a"0t"0t"0h"0e"0w"0 "0J"0."0 "0T"0r"0a"0f"0f"0o"0r"0d"0 "0p"0a"0i"0r"0s"0 "0c"0r"0i"0s"0p"0 "0d"0i"0c"0t"0i"0o"0n"0 "0w"0i"0t"0h"0 "0u"0n"0p"0r"0e"0d"0i"0c"0t"0a"0b"0l"0e"0 "0p"0l"0o"0t"0s"0:"0 "0y"0o"0u"0 "0t"0h"0i"0n"0k"0 "0y"0o"0u "0r"0e"0 "0g"0o"0i"0n"0g"0 "0t"0o"0 "0a"0r"0r"0i"0v"0e"0 "0o"0n"0 "0t"0h"0e"0 "0t"0h"0i"0r"0d"0 "0f"0l"0o"0o"0r"0,"0 "0b"0u"0t"0 "0t"0h"0e"0 "0e"0l"0e"0v"0a"0t"0o"0r"0 "0t"0a"0k"0e"0s"0 "0y"0o"0u"0 "0t"0o"0 "0a"0n"0o"0t"0h"0e"0r"0 "0f"0l"0o"0o"0r"0 "0a"0l"0t"0o"0g"0e"0t"0h"0e"0r"0,"0 "0a"0n"0d"0 "0i"0t"0 "0t"0u"0r"0n"0s"0 "0o"0u"0t"0 "0t"0o"0 "0b"0e"0 "0a"0 "0t"0h"0o"0r"0o"0u"0g"0h"0l"0y"0 "0e"0n"0j"0o"0y"0a"0b"0l"0e"0 "0r"0i"0d"0e &"0 "0a"0 "0m"0u"0s"0t"0 "0f"0o"0r"0 "0r"0e"0a"0d"0e"0r"0s"0 "0l"0o"0o"0k"0i"0n"0g"0 "0f"0o"0r"0 "0s"0o"0m"0e"0t"0h"0i"0n"0g"0 "0f"0r"0e"0s"0h"0 "0a"0m"0i"0d"0 "0a"0 "0s"0e"0a"0 "0o"0f"0 "0s"0t"0a"0l"0e"0 "0b"0o"0o"0k"0s"0.  "0Q"0u"0i"0l"0l"0 "0a"0n"0d"0 "0Q"0u"0i"0r"0e"0 "0
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros