search

storesafe / cordova-sqlite-storage

A Cordova/PhoneGap plugin to open and use sqlite databases on Android, iOS and Windows with HTML5/Web SQL API
Other
2.14k stars 715 forks source link

Bind all numbers as REAL values #684

Open brodycj opened 7 years ago

brodycj commented 7 years ago

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.

khatridev commented 4 years ago

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