安卓SQLite：无法将数据库区域设置更改为'zh_CN'

Question

安卓SQLite：无法将数据库区域设置更改为'zh_CN'

8

有一个类似的问题，

android.database.sqlite.SQLiteException：无法更改db的语言环境 Caused by: android.database.sqlite.SQLiteDatabaseCorruptException：数据库磁盘映像损坏（代码11）

无法将 '/data/data/my.easymedi.controller/databases/EasyMediInfo.db' 的语言环境更改为 'en_US'

但我的数据库是通过SQLiteOpenHelper在Android中创建的。它出现在一些设备上。我想知道是什么原因导致了这个问题，因为我甚至无法重现它。如何解决这个问题？非常感谢！

android.database.sqlite.SQLiteException: Failed to change locale for db '/data/data/com.android.settings/databases/myDB.db' to 'zh_CN'.
at android.database.sqlite.SQLiteConnection.setLocaleFromConfiguration(SQLiteConnection.java:386)
at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:218)
at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:193)
at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)
at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)
at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)
at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:804)
at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:789)
at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:694)
at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:833)
at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:221)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:224)
at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164)
at com.example.optimizecenter.packages.e.mO(PackagesManager.java:150)
at com.example.optimizecenter.packages.PackageSyncService.onHandleIntent(PackageSyncService.java:24)
at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:137)
at android.os.HandlerThread.run(HandlerThread.java:60)
Caused by: android.database.sqlite.SQLiteDatabaseCorruptException: database disk image is malformed (code 11)
at android.database.sqlite.SQLiteConnection.nativeExecuteForString(Native Method)
at android.database.sqlite.SQLiteConnection.executeForString(SQLiteConnection.java:634)
at android.database.sqlite.SQLiteConnection.setLocaleFromConfiguration(SQLiteConnection.java:367)
... 18 more

这是我的辅助类。

public class PackageDataBaseHelper extends SQLiteOpenHelper {

    public PackageDataBaseHelper(Context context) {
        super(context, PackageColumns.DB_NAME, null, PackageColumns.DB_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        StringBuilder sb = new StringBuilder();
        sb.append("create table ");
        sb.append(PackageColumns.TABLE_PACKAGE);
        sb.append(" (");
        sb.append(PackageColumns._ID + " integer primary key autoincrement, ");
        sb.append(PackageColumns.COLUMN_APPLICATION_LABEL + " TEXT ,");
        sb.append(PackageColumns.COLUMN_PACKAGE_NAME + " TEXT ,");
        sb.append(PackageColumns.COLUMN_VERSION_NAME + " TEXT ,");
        sb.append(PackageColumns.COLUMN_VERSION_CODE + " INTEGER ,");
        sb.append(PackageColumns.COLUMN_IC_LAUNCHER + " BOLD");
        sb.append(");");
        db.execSQL(sb.toString());
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // ignore
    }

}

- efei

嘿，这个问题有没有更新？ - hac.jack

1个回答

网页内容由stack overflow 提供, 点击上面的

可以查看英文原文，
原文链接

- lynndragon · Accepted Answer

SQLiteDatabase db=SQLiteDatabase.openDatabase("/data/data/com.android.settings/databases/myDB.db", null,SQLiteDatabase.NO_LOCALIZED_COLLATORS|SQLiteDatabase.CREATE_IF_NECESSARY);

尝试将以下代码示例添加到您的代码中：

如果您有SQLite浏览器，请打开您的数据库。在您的数据库中，android_metadata表的语言环境似乎不是en_US。