troubleshooting Question

Malformed UTF8 characters

Avatar of tonelm54
tonelm54 asked on
SQLPHP
1 Comment1 Solution11 ViewsLast Modified:
I have a PHP script which is trying to convert a recordset to a json object, but its returning error 5 (which after some googling says its a utf8 error). As the records were imported I wanted to check which records have the issue and then correct them, so I wrote the following query to see which recrods are wrong(when I say wrong, I mean not supported by the UTF8 conversion):-
Select `Title`, Convert(`Title` USING utf8), if(`Title`,Convert(`Title` using utf8),0,1) as 'issue' from `myTable` having 'issue'=1;

Open in new window

So, the idea is to look at the `Title` and also the `Title` using utf8 and if they are different display - Problem is there isnt anything outputted, so Im a bit confused.

Any ideas?

ASKER CERTIFIED SOLUTION
Andrei Fomitchev
Sr. DBA

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
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 1 Comment.
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