How to match the picture string in the database?

Question

How to match the picture string in the database?

I have a local dB ( SQLite ) , where the city( i.e., id and title ). Every city has a coat of arms( i.e. I have pictures in the project ). How do I assign each city a coat of arms?
Android Studio Java.

harold.Hil asked July 8th 19 at 15:29

Related questions

More answers about "How to match the picture string in the database?"

2 answers

Donny71 answered on July 8th 19 at 15:33

Can I use base64 to store images in the database. hehehe

Zoey_Barton answered on · Accepted Answer · 2019-07-08T15:31:18.506Z

Zoey_Barton answered on July 8th 19 at 15:31

Solution

Into the database to store the picture name, as a string. Pulling out, get the id of the resource method

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