Check for values being converted when stored in SQLite

SQLite Banner

I hit an annoying problem when testing my Android app on one of my devices (running Android 4.2.2), where values saved into the SQLite database are converted in certain cases.

This is most likely a SQLite issue, but can’t confirm it

So, I created a column in my SQLite Table called “ IsInStock“. The Web API I call to fetch and store data in this table provides a property “ binary options uk law inStock” with a string value of “ two red beans dating 1” or “ source link 0“. My app’s code checks for these values when running queries.

On iOS, the values remain as “ source link 1” and “ follow 0” in the table column, but on my Android device (Android 4.2.2), these values are converted to string values of “ Broker Recensione* Caratteristiche* Fai Trading #1: Deposito minimo 10€! Deposito: 10€ Profitto: 91%* Conto demo Gratuito di 10.000 true” and “ go to site false“. I’m not sure why this is happening and haven’t invested the time to dig deeper. A workaround I went with for now is to extend my SQLite queries to check also for “ buy female viagra uk true” or “ handel mit optionen lernen false” when checking for “ here 1” or “ 0“.

Cheers for now.

Leave a comment

Your email address will not be published. Required fields are marked *