sl@0: [collation1]
sl@0: SPCreateL0=
sl@0: SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
sl@0: SetDBPolicy2=EReadPolicy,ECapabilityWriteUserData
sl@0: CreateSP3=[102827c7]coll.db
sl@0: SPClose4=
sl@0: Exec5=create table names(pkey int primary key, fname text COLLATE CompareC3);
sl@0: Exec6=insert into names(pkey, fname) values(1, "Hämetvaara");
sl@0: Exec7=insert into names(pkey, fname) values(2, "Henry");
sl@0: Exec8=insert into names(pkey, fname) values(3, "Harry");
sl@0: Close9=
sl@0: //Delete10=[102827c7]coll.db
sl@0: EndBlock10=
sl@0: 
sl@0: [collation2]
sl@0: Open0=c:[102827c7]coll.db
sl@0: Prepare1=select * from names order by fname;
sl@0: ColumnIndex2=pkey
sl@0: ColumnIndex3=fname
sl@0: Next4=
sl@0: ColumnInt5=0,1
sl@0: ColumnTextL6=1,Hämetvaara
sl@0: Next7=
sl@0: ColumnInt8=0,3
sl@0: ColumnTextL9=1,Harry
sl@0: Next10=
sl@0: ColumnInt11=0,2
sl@0: ColumnTextL12=1,Henry
sl@0: Next13=
sl@0: St_Close14=
sl@0: Close15=
sl@0: EndBlock16=
sl@0: 
sl@0: [collation3]
sl@0: Function0=CollationTest
sl@0: EndBlock1=