Possible JNI crash due to Unicode emoji characters

[brody4hire]

sqlcipher/android-database-sqlcipher#199 reports that SQLCipher for Android crashes when reading Unicode emoji characters, due to the following bug on Android 1.X-5.X: https://code.google.com/p/android/issues/detail?id=81341

The following code (in Java) reproduces the bug on SQLCipher for Android:

SQLiteStatement st = database.compileStatement("SELECT '\uD83D\uDE03'"); // SMILING FACE (MOUTH OPEN)
String res = st.simpleQueryForString();

I expect to see the same problem in the Android version of this plugin since it also uses JNI through the Android-sqlite-native-driver library. I wonder if this will affect the built-in Android database classes when using androidDatabaseImplementation: 2 in the sqlitePlugin.openDatabase() options.

The bug seems to be fixed on Android 6.0.

Other references:

• http://stackoverflow.com/questions/16786739/how-to-use-unicode-in-android-resource
• https://en.wikipedia.org/wiki/UTF-16#U.2B10000_to_U.2B10FFFF

[mdvacca]

Hi @brodybits, thanks for testing this, Is there any plan to fix this bug for versions previous to Android 6.0?

Thanks,
David.