Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit3e0321f

Browse files
committed
Proper unpack de_DE.ISO-8859-1
1 parentd6429e5 commit3e0321f

16 files changed

+568
-0
lines changed
Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,12 @@
1+
#
2+
# Makefile for example programs
3+
#
4+
5+
all:
6+
-@echo"make: Nothing to be done for\`all'."
7+
8+
test:
9+
@./runall
10+
11+
clean:
12+
rm -f*.out
Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
de_DE.ISO-8859-1 (German) locale test.
2+
Created by Armin Diehl <diehl@net-connection.de>

‎src/test/locale/de_DE.ISO8859-1/expected/de-ctype.out

Lines changed: 257 additions & 0 deletions
Large diffs are not rendered by default.
Lines changed: 23 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,23 @@
1+
name_en | name_de
2+
----------------------+--------------------------------
3+
AAA | ���
4+
aaaaaa | ����
5+
AAAAa | �����
6+
aaaaaaa | aaaaaa
7+
BBBB | BBBB
8+
bbbbbb | bbbbb
9+
BBBBBB | BBBBBBB
10+
CCC | CCCC
11+
ddddd | ddddd
12+
OOOOO | �����
13+
oooooo | ������
14+
OOOOOOO | OOOOOOO
15+
ooooooo | oooooooo
16+
ssssss | ssssss
17+
SSSSSSSS | SSSSSSSS
18+
������ | �������
19+
UU | UU
20+
uuuu | ����
21+
UUUUU | �����
22+
(19 rows)
23+
Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
name_en | name_de
2+
----------------------+---------
3+
AAA | ���
4+
aaaaaa | ����
5+
AAAAa | �����
6+
(3 rows)
7+
Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
Bording
2+
Burg
3+
B�rger
4+
Butter
5+
drang
6+
drang
7+
dr�ngeln
8+
DR�NGELN2
9+
hoardin
10+
hoch
11+
h�he
12+
hose
13+
Saat
14+
S�ge
15+
Sarg
16+
Sorting
17+
�ber
18+
Unter
19+
Z�gern
20+
Zoll
Lines changed: 23 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,23 @@
1+
name_en | name_de
2+
----------------------+----------
3+
AAA | ���
4+
aaaaaa | ����
5+
AAAAa | �����
6+
aaaaaaa | aaaaaa
7+
BBBB | BBBB
8+
bbbbbb | bbbbb
9+
BBBBBB | BBBBBBB
10+
CCC | CCCC
11+
ddddd | ddddd
12+
OOOOO | �����
13+
oooooo | ������
14+
OOOOOOO | OOOOOOO
15+
ooooooo | oooooooo
16+
ssssss | ssssss
17+
SSSSSSSS | SSSSSSSS
18+
������ | �������
19+
UU | UU
20+
uuuu | ����
21+
UUUUU | �����
22+
(19 rows)
23+
Lines changed: 23 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,23 @@
1+
upper
2+
--------------------------------
3+
���
4+
����
5+
�����
6+
AAAAAA
7+
BBBB
8+
BBBBB
9+
BBBBBBB
10+
CCCC
11+
DDDDD
12+
�����
13+
������
14+
OOOOOOO
15+
OOOOOOOO
16+
SSSSSS
17+
SSSSSSSS
18+
�������
19+
UU
20+
����
21+
�����
22+
(19 rows)
23+
Lines changed: 23 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,23 @@
1+
upper
2+
----------
3+
���
4+
����
5+
�����
6+
AAAAAA
7+
BBBB
8+
BBBBB
9+
BBBBBBB
10+
CCCC
11+
DDDDD
12+
�����
13+
������
14+
OOOOOOO
15+
OOOOOOOO
16+
SSSSSS
17+
SSSSSSSS
18+
�������
19+
UU
20+
����
21+
�����
22+
(19 rows)
23+
Lines changed: 23 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,23 @@
1+
upper
2+
----------
3+
���
4+
����
5+
�����
6+
AAAAAA
7+
BBBB
8+
BBBBB
9+
BBBBBBB
10+
CCCC
11+
DDDDD
12+
�����
13+
������
14+
OOOOOOO
15+
OOOOOOOO
16+
SSSSSS
17+
SSSSSSSS
18+
�������
19+
UU
20+
����
21+
�����
22+
(19 rows)
23+
Lines changed: 23 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,23 @@
1+
name_en | name_de
2+
----------------------+----------
3+
AAA | ���
4+
aaaaaa | ����
5+
AAAAa | �����
6+
aaaaaaa | aaaaaa
7+
BBBB | BBBB
8+
bbbbbb | bbbbb
9+
BBBBBB | BBBBBBB
10+
CCC | CCCC
11+
ddddd | ddddd
12+
OOOOO | �����
13+
oooooo | ������
14+
OOOOOOO | OOOOOOO
15+
ooooooo | oooooooo
16+
ssssss | ssssss
17+
SSSSSSSS | SSSSSSSS
18+
������ | �������
19+
UU | UU
20+
uuuu | ����
21+
UUUUU | �����
22+
(19 rows)
23+
Lines changed: 67 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,67 @@
1+
#! /bin/sh
2+
3+
PATH=..:$PATH
4+
5+
echo"Testing PostgreSQL compilation..."
6+
if! test-pgsql-locale;then
7+
exit 1
8+
fi
9+
10+
LC_CTYPE=de_DE.ISO8859-1
11+
LC_COLLATE=$LC_CTYPE
12+
export LC_CTYPE LC_COLLATE
13+
14+
echo"Testing LC_CTYPE..."
15+
if! test-ctype> de-ctype.out;then
16+
exit 1
17+
fi
18+
diff expected/de-ctype.out de-ctype.out
19+
20+
echo"Testing LC_COLLATE..."
21+
perl ../sort-test.pl test-de-sort.in> test-de-sort.out
22+
diff expected/test-de-sort.out test-de-sort.out
23+
24+
### If you have Python - uncomment the following two lines
25+
#python ../sort-test.py test-de-sort.in > test-de-sort.out
26+
#diff expected/test-de-sort.out test-de-sort.out
27+
28+
abort() {
29+
["$1" ]&&echo"$*"
30+
exit 1
31+
}
32+
33+
forfin char varchar text;do
34+
ifecho$f| grep -q char;then
35+
ftype="$f(30)"
36+
else
37+
ftype="$f"
38+
fi
39+
echo"Testing PgSQL: sort on$ftype type..."
40+
41+
dropdb testlocale>/dev/null2>&1
42+
createdb testlocale|| abort"createdb failed"
43+
psql -d testlocale -c"CREATE TABLE wordlist (name_en char(20), name_de$ftype);">/dev/null2>&1|| abort"createtable failed"
44+
psql testlocale< test-de.sql.in> test-de-$f.sql.out2>/dev/null|| abort"test query failed"
45+
diff expected/test-de-$f.sql.out test-de-$f.sql.out
46+
done
47+
48+
forfin char varchar text;do
49+
ifecho$f| grep -q char;then
50+
ftype="$f(30)"
51+
else
52+
ftype="$f"
53+
fi
54+
echo"Testing PgSQL: upper () on$ftype type..."
55+
56+
dropdb testlocale>/dev/null2>&1
57+
createdb testlocale|| abort"createdb failed"
58+
psql -d testlocale -c"CREATE TABLE wordlist (name_en char(20), name_de$ftype);">/dev/null2>&1|| abort"createtable failed"
59+
psql testlocale< test-de-upper.sql.in> test-de-upper-$f.sql.out2>/dev/null|| abort"test query failed"
60+
diff expected/test-de-upper-$f.sql.out test-de-upper-$f.sql.out
61+
done
62+
63+
echo"Testing PgSQL: select on regexp..."
64+
psql testlocale< test-de-select.sql.in> test-de-select.sql.out2>/dev/null|| abort"select query failed"
65+
diff expected/test-de-select.sql.out test-de-select.sql.out
66+
dropdb testlocale|| abort"dropdb failed"
67+
echo"Finished."
Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
SELECT * FROM wordlist WHERE name_de ~* '^�.*' ORDER BY name_de;
Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
Sorting
2+
DR�NGELN2
3+
Sarg
4+
Z�gern
5+
drang
6+
Zoll
7+
h�he
8+
�ber
9+
B�rger
10+
Burg
11+
hoch
12+
hose
13+
Bording
14+
dr�ngeln
15+
Unter
16+
Butter
17+
Saat
18+
S�ge
19+
drang
20+
hoarding
Lines changed: 22 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,22 @@
1+
COPY wordlist FROM stdin USING DELIMITERS '|';
2+
AAA |���
3+
AAAAa |�����
4+
BBBB |BBBB
5+
oooooooo |oooooooo
6+
uuuu |����
7+
UUUUU |�����
8+
CCC |CCCC
9+
aaaaaa |����
10+
������ |�������
11+
aaaaaaa |aaaaaa
12+
bbbbbb |bbbbb
13+
UU |UU
14+
oooooo |������
15+
ddddd |ddddd
16+
OOOOO |�����
17+
OOOOOOO |OOOOOOO
18+
BBBBBB |BBBBBBB
19+
SSSSSSSS |SSSSSSSS
20+
ssssss |ssssss
21+
\.
22+
SELECT upper (name_de) FROM wordlist ORDER BY upper (name_de);
Lines changed: 22 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,22 @@
1+
COPY wordlist FROM stdin USING DELIMITERS '|';
2+
AAA |���
3+
AAAAa |�����
4+
BBBB |BBBB
5+
ooooooo |oooooooo
6+
uuuu |����
7+
UUUUU |�����
8+
CCC |CCCC
9+
aaaaaa |����
10+
������ |�������
11+
aaaaaaa |aaaaaa
12+
bbbbbb |bbbbb
13+
UU |UU
14+
oooooo |������
15+
ddddd |ddddd
16+
OOOOO |�����
17+
OOOOOOO |OOOOOOO
18+
BBBBBB |BBBBBBB
19+
SSSSSSSS |SSSSSSSS
20+
ssssss |ssssss
21+
\.
22+
SELECT * FROM wordlist ORDER BY name_de;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp