os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/collation.ini
author sl@SLION-WIN7.fritz.box
Fri, 15 Jun 2012 03:10:57 +0200
changeset 0 bde4ae8d615e
permissions -rw-r--r--
First public contribution.
     1 [collation1]
     2 SPCreateL0=
     3 SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
     4 SetDBPolicy2=EReadPolicy,ECapabilityWriteUserData
     5 CreateSP3=[102827c7]coll.db
     6 SPClose4=
     7 Exec5=create table names(pkey int primary key, fname text COLLATE CompareC3);
     8 Exec6=insert into names(pkey, fname) values(1, "Hämetvaara");
     9 Exec7=insert into names(pkey, fname) values(2, "Henry");
    10 Exec8=insert into names(pkey, fname) values(3, "Harry");
    11 Close9=
    12 //Delete10=[102827c7]coll.db
    13 EndBlock10=
    14 
    15 [collation2]
    16 Open0=c:[102827c7]coll.db
    17 Prepare1=select * from names order by fname;
    18 ColumnIndex2=pkey
    19 ColumnIndex3=fname
    20 Next4=
    21 ColumnInt5=0,1
    22 ColumnTextL6=1,Hämetvaara
    23 Next7=
    24 ColumnInt8=0,3
    25 ColumnTextL9=1,Harry
    26 Next10=
    27 ColumnInt11=0,2
    28 ColumnTextL12=1,Henry
    29 Next13=
    30 St_Close14=
    31 Close15=
    32 EndBlock16=
    33 
    34 [collation3]
    35 Function0=CollationTest
    36 EndBlock1=