How to match an image to a string in a database?

Question

Java

I have a local db ( SQLite ) where the cities are (i.e. id and title ). Each city has a coat of arms (i.e. I have pictures in the project). How can I give each city its own coat of arms?
android studio, java.

Answer 1

You can store the name of the image in the database as a string. Pulling out, get resource id by method

String imageName = getImageNameFromDB // "gerb"
int id = getResources().getIdentifier(imageName, "drawable", getPackageName());

Answer 2

And you can store images in base64 in the database. hehehe