1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/collation.ini	Fri Jun 15 03:10:57 2012 +0200
     1.3 @@ -0,0 +1,36 @@
     1.4 +[collation1]
     1.5 +SPCreateL0=
     1.6 +SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
     1.7 +SetDBPolicy2=EReadPolicy,ECapabilityWriteUserData
     1.8 +CreateSP3=[102827c7]coll.db
     1.9 +SPClose4=
    1.10 +Exec5=create table names(pkey int primary key, fname text COLLATE CompareC3);
    1.11 +Exec6=insert into names(pkey, fname) values(1, "Hämetvaara");
    1.12 +Exec7=insert into names(pkey, fname) values(2, "Henry");
    1.13 +Exec8=insert into names(pkey, fname) values(3, "Harry");
    1.14 +Close9=
    1.15 +//Delete10=[102827c7]coll.db
    1.16 +EndBlock10=
    1.17 +
    1.18 +[collation2]
    1.19 +Open0=c:[102827c7]coll.db
    1.20 +Prepare1=select * from names order by fname;
    1.21 +ColumnIndex2=pkey
    1.22 +ColumnIndex3=fname
    1.23 +Next4=
    1.24 +ColumnInt5=0,1
    1.25 +ColumnTextL6=1,Hämetvaara
    1.26 +Next7=
    1.27 +ColumnInt8=0,3
    1.28 +ColumnTextL9=1,Harry
    1.29 +Next10=
    1.30 +ColumnInt11=0,2
    1.31 +ColumnTextL12=1,Henry
    1.32 +Next13=
    1.33 +St_Close14=
    1.34 +Close15=
    1.35 +EndBlock16=
    1.36 +
    1.37 +[collation3]
    1.38 +Function0=CollationTest
    1.39 +EndBlock1=