diff -r 000000000000 -r bde4ae8d615e os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/collation.ini --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/collation.ini Fri Jun 15 03:10:57 2012 +0200 @@ -0,0 +1,36 @@ +[collation1] +SPCreateL0= +SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData +SetDBPolicy2=EReadPolicy,ECapabilityWriteUserData +CreateSP3=[102827c7]coll.db +SPClose4= +Exec5=create table names(pkey int primary key, fname text COLLATE CompareC3); +Exec6=insert into names(pkey, fname) values(1, "Hämetvaara"); +Exec7=insert into names(pkey, fname) values(2, "Henry"); +Exec8=insert into names(pkey, fname) values(3, "Harry"); +Close9= +//Delete10=[102827c7]coll.db +EndBlock10= + +[collation2] +Open0=c:[102827c7]coll.db +Prepare1=select * from names order by fname; +ColumnIndex2=pkey +ColumnIndex3=fname +Next4= +ColumnInt5=0,1 +ColumnTextL6=1,Hämetvaara +Next7= +ColumnInt8=0,3 +ColumnTextL9=1,Harry +Next10= +ColumnInt11=0,2 +ColumnTextL12=1,Henry +Next13= +St_Close14= +Close15= +EndBlock16= + +[collation3] +Function0=CollationTest +EndBlock1=