mercredi 20 mai 2015

Remove UTF-8 substring in sqlite

I am trying to remove some invisible characters from a table. I tried this query:

UPDATE table SET text = REPLACE(text, x'202B', '' )

with no luck. I also tried selecting it using:

SELECT REPLACE(text, x'202B', '@@@@') AS text FROM table

but nothing is replaced, so I'm guessing that it can't find x'202B' in the text column, but if I use this query:

SELECT * FROM table WHERE text REGEXP "[\x202B]"

I do get results.

Aucun commentaire:

Enregistrer un commentaire