1- <!-- $PostgreSQL: pgsql/doc/src/sgml/charset.sgml,v 2.48 2005/01/04 00:05:44 momjian Exp $ -->
1+ <!-- $PostgreSQL: pgsql/doc/src/sgml/charset.sgml,v 2.49 2005/03/07 04:30:48 momjian Exp $ -->
22
33<chapter id="charset">
44 <title>Localization</>
@@ -285,7 +285,7 @@ initdb --locale=sv_SE
285285 allows you to store text in a variety of character sets, including
286286 single-byte character sets such as the ISO 8859 series and
287287 multiple-byte character sets such as <acronym>EUC</> (Extended Unix
288- Code),Unicode , and Mule internal code. All character sets can be
288+ Code),UTF8 , and Mule internal code. All character sets can be
289289 used transparently throughout the server. (If you use extension
290290 functions from other sources, it depends on whether they wrote
291291 their code correctly.) The default character set is selected while
@@ -339,8 +339,8 @@ initdb --locale=sv_SE
339339 <entry>Taiwan <acronym>EUC</acronym></entry>
340340 </row>
341341 <row>
342- <entry><literal>UNICODE </literal></entry>
343- <entry>Unicode (<acronym> UTF</acronym>-8 )</entry>
342+ <entry><literal>UTF8 </literal></entry>
343+ <entry>UTF-8 (Unicode, 8-bit )</entry>
344344 </row>
345345 <row>
346346 <entry><literal>MULE_INTERNAL</literal></entry>
@@ -407,7 +407,7 @@ initdb --locale=sv_SE
407407 <entry><acronym>KOI</acronym>8-R(U)</entry>
408408 </row>
409409 <row>
410- <entry><literal>ALT </literal></entry>
410+ <entry><literal>WIN866 </literal></entry>
411411 <entry>Windows CP866</entry>
412412 </row>
413413 <row>
@@ -419,16 +419,16 @@ initdb --locale=sv_SE
419419 <entry>Windows CP1250</entry>
420420 </row>
421421 <row>
422- <entry><literal>WIN </literal></entry>
422+ <entry><literal>WIN1251 </literal></entry>
423423 <entry>Windows CP1251</entry>
424424 </row>
425425 <row>
426426 <entry><literal>WIN1256</literal></entry>
427427 <entry>Windows CP1256 (Arabic)</entry>
428428 </row>
429429 <row>
430- <entry><literal>TCVN </literal></entry>
431- <entry><acronym>TCVN</>-5712/Windows CP1258 (Vietnamese) </entry>
430+ <entry><literal>WIN1258 </literal></entry>
431+ <entry>Windows CP1258 (Vietnamese)/ <acronym>TCVN</>-5712</entry>
432432 </row>
433433 </tbody>
434434 </tgroup>
@@ -504,7 +504,7 @@ $ <userinput>psql -l</userinput>
504504 regression | t-ishii | SQL_ASCII
505505 template1 | t-ishii | EUC_JP
506506 test | t-ishii | EUC_JP
507- unicode | t-ishii |UNICODE
507+ utf8 | t-ishii |UTF8
508508(9 rows)
509509</screen>
510510 </para>
@@ -561,126 +561,126 @@ $ <userinput>psql -l</userinput>
561561 <tbody>
562562 <row>
563563 <entry><literal>SQL_ASCII</literal></entry>
564- <entry><literal>SQL_ASCII</literal>, <literal>UNICODE </literal>, <literal>MULE_INTERNAL</literal>
564+ <entry><literal>SQL_ASCII</literal>, <literal>UTF8 </literal>, <literal>MULE_INTERNAL</literal>
565565 </entry>
566566 </row>
567567 <row>
568568 <entry><literal>EUC_JP</literal></entry>
569569 <entry><literal>EUC_JP</literal>, <literal>SJIS</literal>,
570- <literal>UNICODE </literal>, <literal>MULE_INTERNAL</literal>
570+ <literal>UTF8 </literal>, <literal>MULE_INTERNAL</literal>
571571 </entry>
572572 </row>
573573 <row>
574574 <entry><literal>EUC_CN</literal></entry>
575- <entry><literal>EUC_CN</literal>, <literal>UNICODE </literal>, <literal>MULE_INTERNAL</literal>
575+ <entry><literal>EUC_CN</literal>, <literal>UTF8 </literal>, <literal>MULE_INTERNAL</literal>
576576 </entry>
577577 </row>
578578 <row>
579579 <entry><literal>EUC_KR</literal></entry>
580- <entry><literal>EUC_KR</literal>, <literal>UNICODE </literal>, <literal>MULE_INTERNAL</literal>
580+ <entry><literal>EUC_KR</literal>, <literal>UTF8 </literal>, <literal>MULE_INTERNAL</literal>
581581 </entry>
582582 </row>
583583 <row>
584584 <entry><literal>JOHAB</literal></entry>
585- <entry><literal>JOHAB</literal>, <literal>UNICODE </literal>
585+ <entry><literal>JOHAB</literal>, <literal>UTF8 </literal>
586586 </entry>
587587 </row>
588588 <row>
589589 <entry><literal>EUC_TW</literal></entry>
590590 <entry><literal>EUC_TW</literal>, <literal>BIG5</literal>,
591- <literal>UNICODE </literal>, <literal>MULE_INTERNAL</literal>
591+ <literal>UTF8 </literal>, <literal>MULE_INTERNAL</literal>
592592 </entry>
593593 </row>
594594 <row>
595595 <entry><literal>LATIN1</literal></entry>
596- <entry><literal>LATIN1</literal>, <literal>UNICODE </literal>
596+ <entry><literal>LATIN1</literal>, <literal>UTF8 </literal>
597597 <literal>MULE_INTERNAL</literal>
598598 </entry>
599599 </row>
600600 <row>
601601 <entry><literal>LATIN2</literal></entry>
602602 <entry><literal>LATIN2</literal>, <literal>WIN1250</literal>,
603- <literal>UNICODE </literal>,
603+ <literal>UTF8 </literal>,
604604 <literal>MULE_INTERNAL</literal>
605605 </entry>
606606 </row>
607607 <row>
608608 <entry><literal>LATIN3</literal></entry>
609- <entry><literal>LATIN3</literal>, <literal>UNICODE </literal>,
609+ <entry><literal>LATIN3</literal>, <literal>UTF8 </literal>,
610610 <literal>MULE_INTERNAL</literal>
611611 </entry>
612612 </row>
613613 <row>
614614 <entry><literal>LATIN4</literal></entry>
615- <entry><literal>LATIN4</literal>, <literal>UNICODE </literal>,
615+ <entry><literal>LATIN4</literal>, <literal>UTF8 </literal>,
616616 <literal>MULE_INTERNAL</literal>
617617 </entry>
618618 </row>
619619 <row>
620620 <entry><literal>LATIN5</literal></entry>
621- <entry><literal>LATIN5</literal>, <literal>UNICODE </literal>
621+ <entry><literal>LATIN5</literal>, <literal>UTF8 </literal>
622622 </entry>
623623 </row>
624624 <row>
625625 <entry><literal>LATIN6</literal></entry>
626- <entry><literal>LATIN6</literal>, <literal>UNICODE </literal>,
626+ <entry><literal>LATIN6</literal>, <literal>UTF8 </literal>,
627627 <literal>MULE_INTERNAL</literal>
628628 </entry>
629629 </row>
630630 <row>
631631 <entry><literal>LATIN7</literal></entry>
632- <entry><literal>LATIN7</literal>, <literal>UNICODE </literal>,
632+ <entry><literal>LATIN7</literal>, <literal>UTF8 </literal>,
633633 <literal>MULE_INTERNAL</literal>
634634 </entry>
635635 </row>
636636 <row>
637637 <entry><literal>LATIN8</literal></entry>
638- <entry><literal>LATIN8</literal>, <literal>UNICODE </literal>,
638+ <entry><literal>LATIN8</literal>, <literal>UTF8 </literal>,
639639 <literal>MULE_INTERNAL</literal>
640640 </entry>
641641 </row>
642642 <row>
643643 <entry><literal>LATIN9</literal></entry>
644- <entry><literal>LATIN9</literal>, <literal>UNICODE </literal>,
644+ <entry><literal>LATIN9</literal>, <literal>UTF8 </literal>,
645645 <literal>MULE_INTERNAL</literal>
646646 </entry>
647647 </row>
648648 <row>
649649 <entry><literal>LATIN10</literal></entry>
650- <entry><literal>LATIN10</literal>, <literal>UNICODE </literal>,
650+ <entry><literal>LATIN10</literal>, <literal>UTF8 </literal>,
651651 <literal>MULE_INTERNAL</literal>
652652 </entry>
653653 </row>
654654 <row>
655655 <entry><literal>ISO_8859_5</literal></entry>
656656 <entry><literal>ISO_8859_5</literal>,
657- <literal>UNICODE </literal>,
657+ <literal>UTF8 </literal>,
658658 <literal>MULE_INTERNAL</literal>,
659- <literal>WIN </literal>,
660- <literal>ALT </literal>,
659+ <literal>WIN1251 </literal>,
660+ <literal>WIN866 </literal>,
661661 <literal>KOI8</literal>
662662 </entry>
663663 </row>
664664 <row>
665665 <entry><literal>ISO_8859_6</literal></entry>
666666 <entry><literal>ISO_8859_6</literal>,
667- <literal>UNICODE </literal>
667+ <literal>UTF8 </literal>
668668 </entry>
669669 </row>
670670 <row>
671671 <entry><literal>ISO_8859_7</literal></entry>
672672 <entry><literal>ISO_8859_7</literal>,
673- <literal>UNICODE </literal>
673+ <literal>UTF8 </literal>
674674 </entry>
675675 </row>
676676 <row>
677677 <entry><literal>ISO_8859_8</literal></entry>
678678 <entry><literal>ISO_8859_8</literal>,
679- <literal>UNICODE </literal>
679+ <literal>UTF8 </literal>
680680 </entry>
681681 </row>
682682 <row>
683- <entry><literal>UNICODE </literal></entry>
683+ <entry><literal>UTF8 </literal></entry>
684684 <entry>
685685 <literal>EUC_JP</literal>, <literal>SJIS</literal>,
686686 <literal>EUC_KR</literal>, <literal>UHC</literal>, <literal>JOHAB</literal>,
@@ -691,10 +691,10 @@ $ <userinput>psql -l</userinput>
691691 <literal>ISO_8859_6</literal>,
692692 <literal>ISO_8859_7</literal>,
693693 <literal>ISO_8859_8</literal>,
694- <literal>WIN </literal>, <literal>ALT </literal>,
694+ <literal>WIN1251 </literal>, <literal>WIN866 </literal>,
695695 <literal>KOI8</literal>,
696696 <literal>WIN1256</literal>,
697- <literal>TCVN </literal>,
697+ <literal>WIN1258 </literal>,
698698 <literal>WIN874</literal>,
699699 <literal>GB18030</literal>,
700700 <literal>WIN1250</literal>
@@ -704,53 +704,53 @@ $ <userinput>psql -l</userinput>
704704 <entry><literal>MULE_INTERNAL</literal></entry>
705705 <entry><literal>EUC_JP</literal>, <literal>SJIS</literal>, <literal>EUC_KR</literal>, <literal>EUC_CN</literal>,
706706 <literal>EUC_TW</literal>, <literal>BIG5</literal>, <literal>LATIN1</literal> to <literal>LATIN5</literal>,
707- <literal>WIN </literal>, <literal>ALT </literal>,
707+ <literal>WIN1251 </literal>, <literal>WIN866 </literal>,
708708 <literal>WIN1250</literal>,
709709 <literal>BIG5</literal>, <literal>ISO_8859_5</literal>, <literal>KOI8</literal></entry>
710710 </row>
711711 <row>
712712 <entry><literal>KOI8</literal></entry>
713- <entry><literal>ISO_8859_5</literal>, <literal>WIN </literal>,
714- <literal>ALT </literal>, <literal>KOI8</literal>,
715- <literal>UNICODE </literal>, <literal>MULE_INTERNAL</literal>
713+ <entry><literal>ISO_8859_5</literal>, <literal>WIN1251 </literal>,
714+ <literal>WIN866 </literal>, <literal>KOI8</literal>,
715+ <literal>UTF8 </literal>, <literal>MULE_INTERNAL</literal>
716716 </entry>
717717 </row>
718718 <row>
719- <entry><literal>ALT </literal></entry>
720- <entry><literal>ISO_8859_5</literal>, <literal>WIN </literal>,
721- <literal>ALT </literal>, <literal>KOI8</literal>,
722- <literal>UNICODE </literal>, <literal>MULE_INTERNAL</literal>
719+ <entry><literal>WIN866 </literal></entry>
720+ <entry><literal>ISO_8859_5</literal>, <literal>WIN1251 </literal>,
721+ <literal>WIN866 </literal>, <literal>KOI8</literal>,
722+ <literal>UTF8 </literal>, <literal>MULE_INTERNAL</literal>
723723 </entry>
724724 </row>
725725 <row>
726726 <entry><literal>WIN874</literal></entry>
727727 <entry><literal>WIN874</literal>,
728- <literal>UNICODE </literal>
728+ <literal>UTF8 </literal>
729729 </entry>
730730 </row>
731731 <row>
732732 <entry><literal>WIN1250</literal></entry>
733733 <entry><literal>LATIN2</literal>, <literal>WIN1250</literal>,
734- <literal>UNICODE </literal>, <literal>MULE_INTERNAL</literal>
734+ <literal>UTF8 </literal>, <literal>MULE_INTERNAL</literal>
735735 </entry>
736736 </row>
737737 <row>
738- <entry><literal>WIN </literal></entry>
739- <entry><literal>ISO_8859_5</literal>, <literal>WIN </literal>,
740- <literal>ALT </literal>, <literal>KOI8</literal>,
741- <literal>UNICODE </literal>, <literal>MULE_INTERNAL</literal>
738+ <entry><literal>WIN1251 </literal></entry>
739+ <entry><literal>ISO_8859_5</literal>, <literal>WIN1251 </literal>,
740+ <literal>WIN866 </literal>, <literal>KOI8</literal>,
741+ <literal>UTF8 </literal>, <literal>MULE_INTERNAL</literal>
742742 </entry>
743743 </row>
744744 <row>
745745 <entry><literal>WIN1256</literal></entry>
746746 <entry><literal>WIN1256</literal>,
747- <literal>UNICODE </literal>
747+ <literal>UTF8 </literal>
748748 </entry>
749749 </row>
750750 <row>
751- <entry><literal>TCVN </literal></entry>
752- <entry><literal>TCVN </literal>,
753- <literal>UNICODE </literal>
751+ <entry><literal>WIN1258 </literal></entry>
752+ <entry><literal>WIN1258 </literal>,
753+ <literal>UTF8 </literal>
754754 </entry>
755755 </row>
756756 </tbody>