storesafe/cordova-sqlite-storage

Bind all numbers as REAL values

brodybits opened this issue · 1 comments

Currently the plugin binds integer number values as INTEGER values on Android, iOS with default WebView, and Windows. In contrast the plugin binds whole numbers as REAL values on iOS with cordova-plugin-wkwebview-engine installed and macOS ("osx" platform). Android/iOS WebKit Web SQL also binds whole numbers as REAL numbers.

The plugin should be fixed to bind all number values including integer number values as REAL values. This would provide more consistent behavior on all platforms, behavior more consistent with (WebKit) Web SQL, and be more consistent with the [DRAFT] Web SQL API.

do we have a potential solution for this, I am facing this issue