Link to home
Start Free TrialLog in
Avatar of tonelm54
tonelm54

asked on

Malformed UTF8 characters

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
Avatar of Andrei Fomitchev
Andrei Fomitchev
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial