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

Commit8c3ab66

Browse files
committed
Tweak conversion names to follow the established naming scheme, and
document that scheme.
1 parent87eb561 commit8c3ab66

File tree

4 files changed

+164
-151
lines changed

4 files changed

+164
-151
lines changed

‎doc/src/sgml/func.sgml‎

Lines changed: 61 additions & 48 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.125 2002/09/22 17:27:23 tgl Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.126 2002/09/24 20:14:58 petere Exp $
33
PostgreSQL documentation
44
-->
55

@@ -861,13 +861,15 @@ PostgreSQL documentation
861861
<entry><function>convert</function>(<parameter>string</parameter>
862862
using <parameter>conversion_name</parameter>)</entry>
863863
<entry><type>text</type></entry>
864-
<entry>Change encoding using specified conversion name.
865-
Conversions can be defined by <command>CREATE CONVERSION</command>.
866-
Also there are some pre-defined conversion names.
867-
See <xref linkend="conversion-names"> for available
868-
conversion names. </entry>
869-
<entry><literal>convert('PostgreSQL' using iso8859_1_to_utf8)</literal></entry>
870-
<entry><literal>'PostgreSQL' in UNICODE(UTF-8) encoding</literal></entry>
864+
<entry>
865+
Change encoding using specified conversion name. Conversions
866+
can be defined by <command>CREATE CONVERSION</command>. Also
867+
there are some pre-defined conversion names. See <xref
868+
linkend="conversion-names"> for available conversion
869+
names.
870+
</entry>
871+
<entry><literal>convert('PostgreSQL' using iso_8859_1_to_utf_8)</literal></entry>
872+
<entry><literal>'PostgreSQL'</literal> in UNICODE (UTF-8) encoding</entry>
871873
</row>
872874

873875
<row>
@@ -1291,18 +1293,29 @@ PostgreSQL documentation
12911293

12921294
<para>
12931295
The <function>to_ascii</function> function supports conversion from
1294-
LATIN1,LATIN2, WIN1250 (CP1250) only.
1296+
<literal>LATIN1</>, <literal>LATIN2</>, and <literal>WIN1250</> only.
12951297
</para>
12961298

12971299

12981300
<table id="conversion-names">
1299-
<title>Available conversion names</title>
1301+
<title>Built-in Conversions</title>
13001302
<tgroup cols="3">
13011303
<thead>
13021304
<row>
1303-
<entry>conversion</entry>
1304-
<entry>source encoding</entry>
1305-
<entry>destination encoding</entry>
1305+
<entry>Conversion Name
1306+
<footnote>
1307+
<para>
1308+
The conversion names follow a standard naming scheme: The
1309+
official name of the source encoding with all
1310+
non-alphanumeric characters replaced by underscores followed
1311+
by <literal>_to_</literal> followed by the equally processed
1312+
destination encoding name. Therefore the names might deviate
1313+
from the customary encoding names.
1314+
</para>
1315+
</footnote>
1316+
</entry>
1317+
<entry>Source Encoding</entry>
1318+
<entry>Destination Encoding</entry>
13061319
</row>
13071320
</thead>
13081321

@@ -1464,7 +1477,7 @@ PostgreSQL documentation
14641477
</row>
14651478

14661479
<row>
1467-
<entry><literal>iso_8859_2_to_win1250</literal></entry>
1480+
<entry><literal>iso_8859_2_to_windows_1250</literal></entry>
14681481
<entry><literal>LATIN2</literal></entry>
14691482
<entry><literal>WIN1250</literal></entry>
14701483
</row>
@@ -1494,7 +1507,7 @@ PostgreSQL documentation
14941507
</row>
14951508

14961509
<row>
1497-
<entry><literal>iso_8859_5_to_koi8r</literal></entry>
1510+
<entry><literal>iso_8859_5_to_koi8_r</literal></entry>
14981511
<entry><literal>ISO_8859_5</literal></entry>
14991512
<entry><literal>KOI8</literal></entry>
15001513
</row>
@@ -1512,13 +1525,13 @@ PostgreSQL documentation
15121525
</row>
15131526

15141527
<row>
1515-
<entry><literal>iso_8859_5_to_win1251</literal></entry>
1528+
<entry><literal>iso_8859_5_to_windows_1251</literal></entry>
15161529
<entry><literal>ISO_8859_5</literal></entry>
15171530
<entry><literal>WIN</literal></entry>
15181531
</row>
15191532

15201533
<row>
1521-
<entry><literal>iso_8859_5_to_win866</literal></entry>
1534+
<entry><literal>iso_8859_5_to_windows_866</literal></entry>
15221535
<entry><literal>ISO_8859_5</literal></entry>
15231536
<entry><literal>ALT</literal></entry>
15241537
</row>
@@ -1554,31 +1567,31 @@ PostgreSQL documentation
15541567
</row>
15551568

15561569
<row>
1557-
<entry><literal>koi8r_to_iso_8859_5</literal></entry>
1570+
<entry><literal>koi8_r_to_iso_8859_5</literal></entry>
15581571
<entry><literal>KOI8</literal></entry>
15591572
<entry><literal>ISO_8859_5</literal></entry>
15601573
</row>
15611574

15621575
<row>
1563-
<entry><literal>koi8r_to_mic</literal></entry>
1576+
<entry><literal>koi8_r_to_mic</literal></entry>
15641577
<entry><literal>KOI8</literal></entry>
15651578
<entry><literal>MULE_INTERNAL</literal></entry>
15661579
</row>
15671580

15681581
<row>
1569-
<entry><literal>koi8r_to_utf_8</literal></entry>
1582+
<entry><literal>koi8_r_to_utf_8</literal></entry>
15701583
<entry><literal>KOI8</literal></entry>
15711584
<entry><literal>UNICODE</literal></entry>
15721585
</row>
15731586

15741587
<row>
1575-
<entry><literal>koi8r_to_win1251</literal></entry>
1588+
<entry><literal>koi8_r_to_windows_1251</literal></entry>
15761589
<entry><literal>KOI8</literal></entry>
15771590
<entry><literal>WIN</literal></entry>
15781591
</row>
15791592

15801593
<row>
1581-
<entry><literal>koi8r_to_win866</literal></entry>
1594+
<entry><literal>koi8_r_to_windows_866</literal></entry>
15821595
<entry><literal>KOI8</literal></entry>
15831596
<entry><literal>ALT</literal></entry>
15841597
</row>
@@ -1650,7 +1663,7 @@ PostgreSQL documentation
16501663
</row>
16511664

16521665
<row>
1653-
<entry><literal>mic_to_koi8r</literal></entry>
1666+
<entry><literal>mic_to_koi8_r</literal></entry>
16541667
<entry><literal>MULE_INTERNAL</literal></entry>
16551668
<entry><literal>KOI8</literal></entry>
16561669
</row>
@@ -1662,19 +1675,19 @@ PostgreSQL documentation
16621675
</row>
16631676

16641677
<row>
1665-
<entry><literal>mic_to_win1250</literal></entry>
1678+
<entry><literal>mic_to_windows_1250</literal></entry>
16661679
<entry><literal>MULE_INTERNAL</literal></entry>
16671680
<entry><literal>WIN1250</literal></entry>
16681681
</row>
16691682

16701683
<row>
1671-
<entry><literal>mic_to_win1251</literal></entry>
1684+
<entry><literal>mic_to_windows_1251</literal></entry>
16721685
<entry><literal>MULE_INTERNAL</literal></entry>
16731686
<entry><literal>WIN</literal></entry>
16741687
</row>
16751688

16761689
<row>
1677-
<entry><literal>mic_to_win866</literal></entry>
1690+
<entry><literal>mic_to_windows_866</literal></entry>
16781691
<entry><literal>MULE_INTERNAL</literal></entry>
16791692
<entry><literal>ALT</literal></entry>
16801693
</row>
@@ -1848,7 +1861,7 @@ PostgreSQL documentation
18481861
</row>
18491862

18501863
<row>
1851-
<entry><literal>utf_8_to_koi8r</literal></entry>
1864+
<entry><literal>utf_8_to_koi8_r</literal></entry>
18521865
<entry><literal>UNICODE</literal></entry>
18531866
<entry><literal>KOI8</literal></entry>
18541867
</row>
@@ -1872,121 +1885,121 @@ PostgreSQL documentation
18721885
</row>
18731886

18741887
<row>
1875-
<entry><literal>utf_8_to_win1250</literal></entry>
1888+
<entry><literal>utf_8_to_windows_1250</literal></entry>
18761889
<entry><literal>UNICODE</literal></entry>
18771890
<entry><literal>WIN1250</literal></entry>
18781891
</row>
18791892

18801893
<row>
1881-
<entry><literal>utf_8_to_win1251</literal></entry>
1894+
<entry><literal>utf_8_to_windows_1251</literal></entry>
18821895
<entry><literal>UNICODE</literal></entry>
18831896
<entry><literal>WIN</literal></entry>
18841897
</row>
18851898

18861899
<row>
1887-
<entry><literal>utf_8_to_win1256</literal></entry>
1900+
<entry><literal>utf_8_to_windows_1256</literal></entry>
18881901
<entry><literal>UNICODE</literal></entry>
18891902
<entry><literal>WIN1256</literal></entry>
18901903
</row>
18911904

18921905
<row>
1893-
<entry><literal>utf_8_to_win866</literal></entry>
1906+
<entry><literal>utf_8_to_windows_866</literal></entry>
18941907
<entry><literal>UNICODE</literal></entry>
18951908
<entry><literal>ALT</literal></entry>
18961909
</row>
18971910

18981911
<row>
1899-
<entry><literal>utf_8_to_win874</literal></entry>
1912+
<entry><literal>utf_8_to_windows_874</literal></entry>
19001913
<entry><literal>UNICODE</literal></entry>
19011914
<entry><literal>WIN874</literal></entry>
19021915
</row>
19031916

19041917
<row>
1905-
<entry><literal>win1250_to_iso_8859_2</literal></entry>
1918+
<entry><literal>windows_1250_to_iso_8859_2</literal></entry>
19061919
<entry><literal>WIN1250</literal></entry>
19071920
<entry><literal>LATIN2</literal></entry>
19081921
</row>
19091922

19101923
<row>
1911-
<entry><literal>win1250_to_mic</literal></entry>
1924+
<entry><literal>windows_1250_to_mic</literal></entry>
19121925
<entry><literal>WIN1250</literal></entry>
19131926
<entry><literal>MULE_INTERNAL</literal></entry>
19141927
</row>
19151928

19161929
<row>
1917-
<entry><literal>win1250_to_utf_8</literal></entry>
1930+
<entry><literal>windows_1250_to_utf_8</literal></entry>
19181931
<entry><literal>WIN1250</literal></entry>
19191932
<entry><literal>UNICODE</literal></entry>
19201933
</row>
19211934

19221935
<row>
1923-
<entry><literal>win1251_to_iso_8859_5</literal></entry>
1936+
<entry><literal>windows_1251_to_iso_8859_5</literal></entry>
19241937
<entry><literal>WIN</literal></entry>
19251938
<entry><literal>ISO_8859_5</literal></entry>
19261939
</row>
19271940

19281941
<row>
1929-
<entry><literal>win1251_to_koi8r</literal></entry>
1942+
<entry><literal>windows_1251_to_koi8_r</literal></entry>
19301943
<entry><literal>WIN</literal></entry>
19311944
<entry><literal>KOI8</literal></entry>
19321945
</row>
19331946

19341947
<row>
1935-
<entry><literal>win1251_to_mic</literal></entry>
1948+
<entry><literal>windows_1251_to_mic</literal></entry>
19361949
<entry><literal>WIN</literal></entry>
19371950
<entry><literal>MULE_INTERNAL</literal></entry>
19381951
</row>
19391952

19401953
<row>
1941-
<entry><literal>win1251_to_utf_8</literal></entry>
1954+
<entry><literal>windows_1251_to_utf_8</literal></entry>
19421955
<entry><literal>WIN</literal></entry>
19431956
<entry><literal>UNICODE</literal></entry>
19441957
</row>
19451958

19461959
<row>
1947-
<entry><literal>win1251_to_win866</literal></entry>
1960+
<entry><literal>windows_1251_to_windows_866</literal></entry>
19481961
<entry><literal>WIN</literal></entry>
19491962
<entry><literal>ALT</literal></entry>
19501963
</row>
19511964

19521965
<row>
1953-
<entry><literal>win1256_to_utf_8</literal></entry>
1966+
<entry><literal>windows_1256_to_utf_8</literal></entry>
19541967
<entry><literal>WIN1256</literal></entry>
19551968
<entry><literal>UNICODE</literal></entry>
19561969
</row>
19571970

19581971
<row>
1959-
<entry><literal>win866_to_iso_8859_5</literal></entry>
1972+
<entry><literal>windows_866_to_iso_8859_5</literal></entry>
19601973
<entry><literal>ALT</literal></entry>
19611974
<entry><literal>ISO_8859_5</literal></entry>
19621975
</row>
19631976

19641977
<row>
1965-
<entry><literal>win866_to_koi8r</literal></entry>
1978+
<entry><literal>windows_866_to_koi8_r</literal></entry>
19661979
<entry><literal>ALT</literal></entry>
19671980
<entry><literal>KOI8</literal></entry>
19681981
</row>
19691982

19701983
<row>
1971-
<entry><literal>win866_to_mic</literal></entry>
1984+
<entry><literal>windows_866_to_mic</literal></entry>
19721985
<entry><literal>ALT</literal></entry>
19731986
<entry><literal>MULE_INTERNAL</literal></entry>
19741987
</row>
19751988

19761989
<row>
1977-
<entry><literal>win866_to_utf_8</literal></entry>
1990+
<entry><literal>windows_866_to_utf_8</literal></entry>
19781991
<entry><literal>ALT</literal></entry>
19791992
<entry><literal>UNICODE</literal></entry>
19801993
</row>
19811994

19821995
<row>
1983-
<entry><literal>win866_to_win1251</literal></entry>
1996+
<entry><literal>windows_866_to_windows_1251</literal></entry>
19841997
<entry><literal>ALT</literal></entry>
19851998
<entry><literal>WIN</literal></entry>
19861999
</row>
19872000

19882001
<row>
1989-
<entry><literal>win874_to_utf_8</literal></entry>
2002+
<entry><literal>windows_874_to_utf_8</literal></entry>
19902003
<entry><literal>WIN874</literal></entry>
19912004
<entry><literal>UNICODE</literal></entry>
19922005
</row>
@@ -2310,7 +2323,7 @@ PostgreSQL documentation
23102323

23112324
<indexterm zone="functions-sql99-regexp">
23122325
<primary>regular expressions</primary>
2313-
<seealso>pattern matching</seealso>
2326+
<!-- <seealso>pattern matching</seealso> breaks index build -->
23142327
</indexterm>
23152328

23162329
<indexterm>

0 commit comments

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