|
sl@0
|
1 |
[collation1]
|
|
sl@0
|
2 |
SPCreateL0=
|
|
sl@0
|
3 |
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
|
|
sl@0
|
4 |
SetDBPolicy2=EReadPolicy,ECapabilityWriteUserData
|
|
sl@0
|
5 |
CreateSP3=[102827c7]coll.db
|
|
sl@0
|
6 |
SPClose4=
|
|
sl@0
|
7 |
Exec5=create table names(pkey int primary key, fname text COLLATE CompareC3);
|
|
sl@0
|
8 |
Exec6=insert into names(pkey, fname) values(1, "Hämetvaara");
|
|
sl@0
|
9 |
Exec7=insert into names(pkey, fname) values(2, "Henry");
|
|
sl@0
|
10 |
Exec8=insert into names(pkey, fname) values(3, "Harry");
|
|
sl@0
|
11 |
Close9=
|
|
sl@0
|
12 |
//Delete10=[102827c7]coll.db
|
|
sl@0
|
13 |
EndBlock10=
|
|
sl@0
|
14 |
|
|
sl@0
|
15 |
[collation2]
|
|
sl@0
|
16 |
Open0=c:[102827c7]coll.db
|
|
sl@0
|
17 |
Prepare1=select * from names order by fname;
|
|
sl@0
|
18 |
ColumnIndex2=pkey
|
|
sl@0
|
19 |
ColumnIndex3=fname
|
|
sl@0
|
20 |
Next4=
|
|
sl@0
|
21 |
ColumnInt5=0,1
|
|
sl@0
|
22 |
ColumnTextL6=1,Hämetvaara
|
|
sl@0
|
23 |
Next7=
|
|
sl@0
|
24 |
ColumnInt8=0,3
|
|
sl@0
|
25 |
ColumnTextL9=1,Harry
|
|
sl@0
|
26 |
Next10=
|
|
sl@0
|
27 |
ColumnInt11=0,2
|
|
sl@0
|
28 |
ColumnTextL12=1,Henry
|
|
sl@0
|
29 |
Next13=
|
|
sl@0
|
30 |
St_Close14=
|
|
sl@0
|
31 |
Close15=
|
|
sl@0
|
32 |
EndBlock16=
|
|
sl@0
|
33 |
|
|
sl@0
|
34 |
[collation3]
|
|
sl@0
|
35 |
Function0=CollationTest
|
|
sl@0
|
36 |
EndBlock1=
|