1- <!-- $Header: /cvsroot/pgsql/doc/src/sgml/charset.sgml,v 2.14 2001/11/12 19:19:39 petere Exp $ -->
1+ <!-- $Header: /cvsroot/pgsql/doc/src/sgml/charset.sgml,v 2.15 2001/11/15 06:15:34 ishii Exp $ -->
22
33<chapter id="charset">
44 <title>Localization</>
@@ -310,7 +310,7 @@ perl: warning: Falling back to the standard locale ("C").
310310 <tbody>
311311<row>
312312 <entry><literal>SQL_ASCII</literal></entry>
313- <entry><acronym>ASCII</acronym></entry>
313+ <entry><acronym>US ASCII</acronym></entry>
314314</row>
315315<row>
316316 <entry><literal>EUC_JP</literal></entry>
@@ -334,27 +334,63 @@ perl: warning: Falling back to the standard locale ("C").
334334</row>
335335<row>
336336 <entry><literal>MULE_INTERNAL</literal></entry>
337- <entry>Mule internal</entry>
337+ <entry>Mule internal code </entry>
338338</row>
339339<row>
340340 <entry><literal>LATIN1</literal></entry>
341- <entry>ISO 8859-1English and some European languages </entry>
341+ <entry>ISO 8859-1ECMA-94 Latin Alphabet No.1 </entry>
342342</row>
343343<row>
344344 <entry><literal>LATIN2</literal></entry>
345- <entry>ISO 8859-2English and some European languages </entry>
345+ <entry>ISO 8859-2ECMA-94 Latin Alphabet No.2 </entry>
346346</row>
347347<row>
348348 <entry><literal>LATIN3</literal></entry>
349- <entry>ISO 8859-3English and some European languages </entry>
349+ <entry>ISO 8859-3ECMA-94 Latin Alphabet No.3 </entry>
350350</row>
351351<row>
352352 <entry><literal>LATIN4</literal></entry>
353- <entry>ISO 8859-4English and some European languages </entry>
353+ <entry>ISO 8859-4ECMA-94 Latin Alphabet No.4 </entry>
354354</row>
355355<row>
356356 <entry><literal>LATIN5</literal></entry>
357- <entry>ISO 8859-5 English and some European languages</entry>
357+ <entry>ISO 8859-9 ECMA-128 Latin Alphabet No.5</entry>
358+ </row>
359+ <row>
360+ <entry><literal>LATIN6</literal></entry>
361+ <entry>ISO 8859-10 ECMA-144 Latin Alphabet No.6</entry>
362+ </row>
363+ <row>
364+ <entry><literal>LATIN7</literal></entry>
365+ <entry>ISO 8859-13 Latin Alphabet No.7</entry>
366+ </row>
367+ <row>
368+ <entry><literal>LATIN8</literal></entry>
369+ <entry>ISO 8859-14 Latin Alphabet No.8</entry>
370+ </row>
371+ <row>
372+ <entry><literal>LATIN9</literal></entry>
373+ <entry>ISO 8859-15 Latin Alphabet No.9</entry>
374+ </row>
375+ <row>
376+ <entry><literal>LATIN10</literal></entry>
377+ <entry>ISO 8859-16 ASRO SR 14111 Latin Alphabet No.10</entry>
378+ </row>
379+ <row>
380+ <entry><literal>ISO-8859-5</literal></entry>
381+ <entry>ECMA-113 Latin/Cyrillic</entry>
382+ </row>
383+ <row>
384+ <entry><literal>ISO-8859-6</literal></entry>
385+ <entry>ECMA-114 Latin/Arabic</entry>
386+ </row>
387+ <row>
388+ <entry><literal>ISO-8859-7</literal></entry>
389+ <entry>ECMA-118 Latin/Greek</entry>
390+ </row>
391+ <row>
392+ <entry><literal>ISO-8859-8</literal></entry>
393+ <entry>ECMA-121 Latin/Hebrew</entry>
358394</row>
359395<row>
360396 <entry><literal>KOI8</literal></entry>
@@ -373,6 +409,19 @@ perl: warning: Falling back to the standard locale ("C").
373409 </table>
374410 </para>
375411
412+ <para>
413+ CAUTION1: Note that before 7.2 LATIN5 meant ISO 8859-5 mistakely. In 7.2
414+ LATIN5 measn ISO 8859-9. If you have LATIN5 database created on
415+ 7.1 or before and want to migrate to 7.2, you should be very
416+ carefull about this change.
417+ </para>
418+
419+ <para>
420+ CAUTION2: Not all API supports encodings listed above. For example,
421+ PostgreSQL JDBC driver does not support MULE_INTERNAL, LATIN6,
422+ LATIN8 and LATIN10.
423+ </para>
424+
376425 <para>
377426 Here is an example of configuring
378427 <productname>Postgres</productname> to use a Japanese encoding by
@@ -466,28 +515,157 @@ $ psql -l
466515</row>
467516 </thead>
468517 <tbody>
518+ <row>
519+ <entry><literal>SQL_ASCII</literal></entry>
520+ <entry><literal>SQL_ASCII</literal>, <literal>UNICODE</literal>, <literal>MULE_INTERNAL</literal>
521+ </entry>
522+ </row>
469523<row>
470524 <entry><literal>EUC_JP</literal></entry>
471- <entry><literal>EUC_JP</literal>, <literal>SJIS</literal></entry>
525+ <entry><literal>EUC_JP</literal>, <literal>SJIS</literal>,
526+ <literal>UNICODE</literal>, <literal>MULE_INTERNAL</literal>
527+ </entry>
472528</row>
473529<row>
474530 <entry><literal>EUC_TW</literal></entry>
475- <entry><literal>EUC_TW</literal>, <literal>BIG5</literal></entry>
531+ <entry><literal>EUC_TW</literal>, <literal>BIG5</literal>,
532+ <literal>UNICODE</literal>, <literal>MULE_INTERNAL</literal>
533+ </entry>
534+ </row>
535+ <row>
536+ <entry><literal>LATIN1</literal></entry>
537+ <entry><literal>LATIN1</literal>, <literal>UNICODE</literal>
538+ <literal>MULE_INTERNAL</literal>
539+ </entry>
476540</row>
477541<row>
478542 <entry><literal>LATIN2</literal></entry>
479- <entry><literal>LATIN2</literal>, <literal>WIN1250</literal></entry>
543+ <entry><literal>LATIN2</literal>, <literal>WIN1250</literal>,
544+ <literal>UNICODE</literal>,
545+ <literal>MULE_INTERNAL</literal>
546+ </entry>
480547</row>
481- <row>
548+ <row>
549+ <entry><literal>LATIN3</literal></entry>
550+ <entry><literal>LATIN3</literal>, <literal>UNICODE</literal>
551+ <literal>MULE_INTERNAL</literal>
552+ </entry>
553+ </row>
554+ <row>
555+ <entry><literal>LATIN4</literal></entry>
556+ <entry><literal>LATIN4</literal>, <literal>UNICODE</literal>
557+ <literal>MULE_INTERNAL</literal>
558+ </entry>
559+ </row>
560+ <row>
482561 <entry><literal>LATIN5</literal></entry>
483- <entry><literal>LATIN5</literal>, <literal>WIN</literal>, <literal>ALT</literal></entry>
562+ <entry><literal>LATIN5</literal>, <literal>UNICODE</literal>
563+ <literal>MULE_INTERNAL</literal>
564+ </entry>
565+ </row>
566+ <row>
567+ <entry><literal>LATIN6</literal></entry>
568+ <entry><literal>LATIN6</literal>, <literal>UNICODE</literal>
569+ <literal>MULE_INTERNAL</literal>
570+ </entry>
571+ </row>
572+ <row>
573+ <entry><literal>LATIN7</literal></entry>
574+ <entry><literal>LATIN7</literal>, <literal>UNICODE</literal>
575+ <literal>MULE_INTERNAL</literal>
576+ </entry>
577+ </row>
578+ <row>
579+ <entry><literal>LATIN8</literal></entry>
580+ <entry><literal>LATIN8</literal>, <literal>UNICODE</literal>
581+ <literal>MULE_INTERNAL</literal>
582+ </entry>
583+ </row>
584+ <row>
585+ <entry><literal>LATIN9</literal></entry>
586+ <entry><literal>LATIN9</literal>, <literal>UNICODE</literal>
587+ <literal>MULE_INTERNAL</literal>
588+ </entry>
589+ </row>
590+ <row>
591+ <entry><literal>LATIN10</literal></entry>
592+ <entry><literal>LATIN10</literal>, <literal>UNICODE</literal>
593+ <literal>MULE_INTERNAL</literal>
594+ </entry>
595+ </row>
596+ <row>
597+ <entry><literal>ISO_8859_5</literal></entry>
598+ <entry><literal>ISO_8859_5</literal>,
599+ <literal>UNICODE</literal>
600+ </entry>
601+ </row>
602+ <row>
603+ <entry><literal>ISO_8859_6</literal></entry>
604+ <entry><literal>ISO_8859_6</literal>,
605+ <literal>UNICODE</literal>
606+ </entry>
607+ </row>
608+ <row>
609+ <entry><literal>ISO_8859_7</literal></entry>
610+ <entry><literal>ISO_8859_7</literal>,
611+ <literal>UNICODE</literal>
612+ </entry>
613+ </row>
614+ <row>
615+ <entry><literal>ISO_8859_8</literal></entry>
616+ <entry><literal>ISO_8859_8</literal>,
617+ <literal>UNICODE</literal>
618+ </entry>
619+ </row>
620+ <row>
621+ <entry><literal>ISO_8859_9</literal></entry>
622+ <entry><literal>ISO_8859_9</literal>, <literal>WIN</literal>,
623+ <literal>ALT</literal>, <literal>KOI8R</literal>,
624+ <literal>UNICODE</literal>, <literal>MULE_INTERNAL</literal>
625+ </entry>
626+ </row>
627+ <row>
628+ <entry><literal>UNICODE</literal></entry>
629+ <entry>
630+ <literal>EUC_JP</literal>, <literal>SJIS</literal>,
631+ <literal>EUC_KR</literal>, <literal>EUC_CN</literal>,
632+ <literal>EUC_TW</literal>, <literal>BIG5</literal>,
633+ <literal>LATIN1</literal> to <literal>LATIN10</literal>,
634+ <literal>ISO_8859_5</literal>,
635+ <literal>ISO_8859_6</literal>,
636+ <literal>ISO_8859_7</literal>,
637+ <literal>ISO_8859_8</literal>,
638+ <literal>WIN</literal>, <literal>ALT</literal>,
639+ <literal>KOI8</literal>
640+ </entry>
484641</row>
485642<row>
486643 <entry><literal>MULE_INTERNAL</literal></entry>
487644 <entry><literal>EUC_JP</literal>, <literal>SJIS</literal>, <literal>EUC_KR</literal>, <literal>EUC_CN</literal>,
488645 <literal>EUC_TW</literal>, <literal>BIG5</literal>, <literal>LATIN1</literal> to <literal>LATIN5</literal>,
489646 <literal>WIN</literal>, <literal>ALT</literal>, <literal>WIN1250</literal></entry>
490647</row>
648+ <row>
649+ <entry><literal>KOI8</literal></entry>
650+ <entry><literal>ISO_8859_9</literal>, <literal>WIN</literal>,
651+ <literal>ALT</literal>, <literal>KOI8</literal>,
652+ <literal>UNICODE</literal>, <literal>MULE_INTERNAL</literal>
653+ </entry>
654+ </row>
655+ <row>
656+ <entry><literal>WIN</literal></entry>
657+ <entry><literal>ISO_8859_9</literal>, <literal>WIN</literal>,
658+ <literal>ALT</literal>, <literal>KOI8</literal>,
659+ <literal>UNICODE</literal>, <literal>MULE_INTERNAL</literal>
660+ </entry>
661+ </row>
662+ <row>
663+ <entry><literal>ALT</literal></entry>
664+ <entry><literal>ISO_8859_9</literal>, <literal>WIN</literal>,
665+ <literal>ALT</literal>, <literal>KOI8</literal>,
666+ <literal>UNICODE</literal>, <literal>MULE_INTERNAL</literal>
667+ </entry>
668+ </row>
491669 </tbody>
492670 </tgroup>
493671 </table>
@@ -596,11 +774,16 @@ RESET CLIENT_ENCODING;
596774 <para>
597775 An automatic encoding translation between Unicode and other
598776 encodings has been supported since PostgreSQL 7.1.
599- Because this requires huge conversion tables, it's not enabled by default.
777+ For 7.1 it's not enabled by default.
600778 To enable this feature, run configure with the
601779 <option>--enable-unicode-conversion</option> option. Note that this requires
602780 the <option>--enable-multibyte</option> option also.
603781 </para>
782+ <para>
783+ For 7.2, <option>--enable-unicode-conversion</option> is not necessary.
784+ The unicode conversion functionality is automatically enabled
785+ if <option>--enable-multibyte</option> is specified.
786+ </para>
604787 </sect2>
605788
606789 <sect2>