FWIW, I created issue 27053: 
http://code.google.com/p/android/issues/detail?id=27053

This code snippet was included; I will probably end up using it to
test the phone when the app first runs. Ugh.


package com.some.name;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class UnicodeBroken {
        public static boolean isBroken(SQLiteDatabase db) {
                db.execSQL("Drop Table If Exists unicode_broken");
                db.execSQL("Create Table unicode_broken (f text collate 
UNICODE, i
int)");
                db.execSQL("insert into unicode_broken values ('a', 1)");
                db.execSQL("insert into unicode_broken values ('A', 2)");
                Cursor c = db.rawQuery("Select * from unicode_broken order by f
collate UNICODE, i", new String[] {});
                try {
                        c.moveToFirst();
                        String s = c.getString(0);
                        return !s.equals("a");
                } finally {
                        c.close();
                }
        }
}

-- 
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

Reply via email to