java - SQLite certain word colors -

im busy bible app , want have text references in different color rest of text. there way this? use sqlite db thats in assets folder edit data in db browser , not in android studio strings.

i want know if possible <textcolor>word<textcolor> , when in android studio should not display words in brackets color. ive got example uses in php doesnt work in sqlite

<sup><font color="#3923d6">words in color goes here</font></sup>

is there workaround make work in adroid studio?

well, i'm assuming want display name of color in it's respective color, if text red , want red displayed in red color.

for can store values in database this

 "<font color='red'>red</font>." 

you can make column in table text not null

once fetch data table can display in textview follow

 textview.settext(html.fromhtml(colortext), textview.buffertype.spannable); 

here colortext string value retrieved database.