Hi SQLiters, I am trying to clean up some text in a database that has some weird non-printable unicode characters.
For instance: .mode insert select distinct "Name", length ("Name"), substr("Name",-1,1) from "My Table" gives: INSERT INTO table VALUES('Roundup Ready®',15,'') As you can see, the printable text is only 14 characters long, but there are actually 15 characters there, as confirmed by the length result. This weird extra character seems to have the unicode hex value of f87f and appears in various positions (not just the end) of text. I want to remove it, but can't figure out how. I've tried: replace("Name", x'f87f', '') but it doesn't seem to match the weird character. Any ideas? Thanks, Tom _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users