CODEWITHSUNDEEP
sqldatabasesqlitesql-updateandroid-sqlite
VSB
VSB

Reputation: 10375

Replace special characters in SQLITE TEXT record

I got a SQLITE database in android application. In order to increase application performance i want to do some refinement on DB before adding it to android app.
In order to do this:
I want to remove/replace special characters in Name field of Account table. Unicode of those special characters are in range 8204-8207 (0x200C ~ 0x200F). What is the correct SQL syntax to update Account Table?

Upvotes: 5

Views: 4506

Answers (1)

Steve Bergamini
Steve Bergamini

Reputation: 14600

SQLite supports the REPLACE function. See this documentation: http://sqlite.org/lang_corefunc.html

Therefore, you should be able to do something like this:

UPDATE Account
SET Name= REPLACE(Name,'char-to-replace','replacement');

Upvotes: 4

Related Questions