CODEWITHSUNDEEP
phpmysqlutf-8
Matteo Bononi 'peorthyr'
Matteo Bononi 'peorthyr'

Reputation: 2220

locate invisible utf8 characters in mySQL database

I have a database in where I have found some field with NON UTF8 characters inside. In fact, if i edit the field value with phpmyadmin, copy the value of the field, paste it on notepad++, and change the encoding, I see this character  while there is nothing if i change the charset to utf8 no BOM.

I need to find a way to search and delete all those ANSI visibile characters in the mySQL tables, consider that those character are visible only if I paste the value in notepad++

please if someone has an idea, anything is apreciated.

this question is related to this problem:another question

Upvotes: 0

Views: 296

Answers (1)

user3560014
user3560014

Reputation: 46

You can try this:

select * from tableName where fieldName regexp '[^ -~]';

Upvotes: 1

Related Questions