> I've tried:
> replace("Name", x'f87f', '') but it doesn't seem to match the weird character.
> Any ideas?I guess x'f87f' will match your character only if your database is in UTF-16. For UTF-8 you probably should try x'efa1bf'. And maybe explicit conversion to text is needed. Pavel On Mon, Oct 3, 2011 at 10:14 AM, BareFeetWare <[email protected]> wrote: > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
