{"action":"opened","issue":{"url":"https://api.github.com/repos/commonsguy/cwac-saferoom/issues/30","repository_url":"https://api.github.com/repos/commonsguy/cwac-saferoom","labels_url":"https://api.github.com/repos/commonsguy/cwac-saferoom/issues/30/labels{/name}","comments_url":"https://api.github.com/repos/commonsguy/cwac-saferoom/issues/30/comments","events_url":"https://api.github.com/repos/commonsguy/cwac-saferoom/issues/30/events","html_url":"https://github.com/commonsguy/cwac-saferoom/issues/30","id":372873828,"node_id":"MDU6SXNzdWUzNzI4NzM4Mjg=","number":30,"title":"COLLATION: SQLiteException: no such collation sequence: UNICODE (AndroidX)","user":{"login":"dunda123","id":29466014,"node_id":"MDQ6VXNlcjI5NDY2MDE0","avatar_url":"https://avatars0.githubusercontent.com/u/29466014?v=4","gravatar_id":"","url":"https://api.github.com/users/dunda123","html_url":"https://github.com/dunda123","followers_url":"https://api.github.com/users/dunda123/followers","following_url":"https://api.github.com/users/dunda123/following{/other_user}","gists_url":"https://api.github.com/users/dunda123/gists{/gist_id}","starred_url":"https://api.github.com/users/dunda123/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dunda123/subscriptions","organizations_url":"https://api.github.com/users/dunda123/orgs","repos_url":"https://api.github.com/users/dunda123/repos","events_url":"https://api.github.com/users/dunda123/events{/privacy}","received_events_url":"https://api.github.com/users/dunda123/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-10-23T08:33:57Z","updated_at":"2018-10-23T08:33:57Z","closed_at":null,"author_association":"NONE","body":"1. Empty DB, Class (table) User with column \r\n\r\n@ColumnInfo(collate = ColumnInfo.UNICODE, name=\"last_name\")\r\nString last_name;\r\n\r\nWhen I call query:\r\nQuery(\"SELECT * FROM user ORDER BY last_name\")\r\n\r\nError:\r\n2018-10-23 10:16:06.643 17839-17914/cz.dunda.android.testy.roomtest E/AndroidRuntime: FATAL EXCEPTION: arch_disk_io_0\r\n    Process: cz.dunda.android.testy.roomtest, PID: 17839\r\n    net.sqlcipher.database.SQLiteException: no such collation sequence: UNICODE: CREATE TABLE IF NOT EXISTS `User` (`uid` INTEGER PRIMARY KEY AUTOINCREMENT, `first_name` TEXT NOT NULL, `last_name` TEXT NOT NULL COLLATE UNICODE)\r\n        at net.sqlcipher.database.SQLiteDatabase.native_execSQL(Native Method)\r\n        at net.sqlcipher.database.SQLiteDatabase.execSQL(SQLiteDatabase.java:2265)\r\n        at com.commonsware.cwac.saferoom.Database.execSQL(Database.java:350)\r\n        at cz.dunda.android.testy.roomtest.AppDatabase_Impl$1.createAllTables(AppDatabase_Impl.java:33)\r\n        at androidx.room.RoomOpenHelper.onCreate(RoomOpenHelper.java:74)\r\n        at com.commonsware.cwac.saferoom.Helper$1.onCreate(Helper.java:52)\r\n        at net.sqlcipher.database.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:171)\r\n        at com.commonsware.cwac.saferoom.Helper$OpenHelper.getWritableSupportDatabase(Helper.java:157)\r\n        at com.commonsware.cwac.saferoom.Helper.getWritableDatabase(Helper.java:119)\r\n        at androidx.room.RoomDatabase.query(RoomDatabase.java:251)\r\n        at androidx.room.util.DBUtil.query(DBUtil.java:54)\r\n        at cz.dunda.android.testy.roomtest.UserDao_Impl$3.compute(UserDao_Impl.java:237)\r\n        at cz.dunda.android.testy.roomtest.UserDao_Impl$3.compute(UserDao_Impl.java:223)\r\n        at androidx.lifecycle.ComputableLiveData$2.run(ComputableLiveData.java:101)\r\n\r\nWithout Saferoom is all ok.\r\n\r\n2. Insert\r\nError:\r\nnet.sqlcipher.database.SQLiteException: no such collation sequence: UNICODE: CREATE TABLE IF NOT EXISTS `User` (`uid` INTEGER PRIMARY KEY AUTOINCREMENT, `first_name` TEXT NOT NULL, `last_name` TEXT NOT NULL COLLATE UNICODE)\r\n\r\nIf I don't use Saferoom, insert and query work correctly and sorting too.\r\n\r\nThank you for your help and this library.\r\n\r\nZdenek.\r\n"}}
{"actor":{"display_login":"dunda123"}}