Home > Enterprise >  Sqlite DB works in Flutter Android App but not in iOS
Sqlite DB works in Flutter Android App but not in iOS

Time:03-24

I built a simple Flutter App for Android and iOS. This app only searches for a medical term in an SQLite DB and shows the description matching for that term.

I managed to run the app on both, Android and iOS devices but with a slight difference:

In Android, the app works well, but in iOS, although I managed to run it on my iPhone device, it works only partially. When I search in some categories, it shows me the results, but in some other categories, it doesn't. Seems like it's maybe using the old SQLite DB? (since I updated it recently to add more terms).

Do any of you have an idea of why is this happening or have had similar problems in the past? Should I do something on iOS if I change DB content? I'm really stuck in here.

Thank you so much in advance, if you need more detail or some screenshots, just let me know.

CodePudding user response:

After digging a lot and trying many different things, I realized something really simple:

When I selected categories with accents (like Cardiología) it didn't work. When I selected categories without accents (like Medicina General) it worked!!!

So although it wasn't the best solution and I bet there are some best ones, I just deleted all accents in my DB and now my app works fine in both, Android and iOS.

  • Related