1- <!-- $PostgreSQL: pgsql/doc/src/sgml/charset.sgml,v 2.65 2005/03/13 22:04:29 momjian Exp $ -->
1+ <!-- $PostgreSQL: pgsql/doc/src/sgml/charset.sgml,v 2.66 2005/03/14 02:14:42 momjian Exp $ -->
22
33<chapter id="charset">
44 <title>Localization</>
@@ -312,6 +312,7 @@ initdb --locale=sv_SE
312312 <entry>Name</entry>
313313 <entry>Description</entry>
314314 <entry>Language</entry>
315+ <entry>Bytes/Char</entry>
315316 <entry>Aliases</entry>
316317 </row>
317318 </thead>
@@ -320,205 +321,239 @@ initdb --locale=sv_SE
320321 <entry><literal>BIG5</literal></entry>
321322 <entry>Big Five</entry>
322323 <entry>Traditional Chinese</entry>
323- <entry>WIN950, Windows950</entry>
324+ <entry>1-2</entry>
325+ <entry><literal>WIN950</>, <literal>Windows950</></entry>
324326 </row>
325327 <row>
326328 <entry><literal>EUC_CN</literal></entry>
327329 <entry>Extended UNIX Code-CN</entry>
328330 <entry>Simplified Chinese</entry>
331+ <entry>1-3</entry>
329332 <entry></entry>
330333 </row>
331334 <row>
332335 <entry><literal>EUC_JP</literal></entry>
333336 <entry>Extended UNIX Code-JP</entry>
334337 <entry>Japanese</entry>
338+ <entry>1-3</entry>
335339 <entry></entry>
336340 </row>
337341 <row>
338342 <entry><literal>EUC_KR</literal></entry>
339343 <entry>Extended UNIX Code-KR</entry>
340344 <entry>Korean</entry>
345+ <entry>1-3</entry>
341346 <entry></entry>
342347 </row>
343348 <row>
344349 <entry><literal>EUC_TW</literal></entry>
345350 <entry>Extended UNIX Code-TW</entry>
346351 <entry>Traditional Chinese, Taiwanese</entry>
352+ <entry>1-3</entry>
347353 <entry></entry>
348354 </row>
349355 <row>
350356 <entry><literal>GB18030</literal></entry>
351357 <entry>National Standard</entry>
352358 <entry>Chinese</entry>
359+ <entry>1-2</entry>
353360 <entry></entry>
354361 </row>
355362 <row>
356363 <entry><literal>GBK</literal></entry>
357364 <entry>Extended National Standard</entry>
358365 <entry>Simplified Chinese</entry>
359- <entry>WIN936, Windows936</entry>
366+ <entry>1-2</entry>
367+ <entry><literal>WIN936</>, <literal>Windows936</></entry>
360368 </row>
361369 <row>
362370 <entry><literal>ISO_8859_5</literal></entry>
363371 <entry>ISO 8859-5, <acronym>ECMA</> 113</entry>
364372 <entry>Latin/Cyrillic</entry>
373+ <entry>1</entry>
365374 <entry></entry>
366375 </row>
367376 <row>
368377 <entry><literal>ISO_8859_6</literal></entry>
369378 <entry>ISO 8859-6, <acronym>ECMA</> 114</entry>
370379 <entry>Latin/Arabic</entry>
380+ <entry>1</entry>
371381 <entry></entry>
372382 </row>
373383 <row>
374384 <entry><literal>ISO_8859_7</literal></entry>
375385 <entry>ISO 8859-7, <acronym>ECMA</> 118</entry>
376386 <entry>Latin/Greek</entry>
387+ <entry>1</entry>
377388 <entry></entry>
378389 </row>
379390 <row>
380391 <entry><literal>ISO_8859_8</literal></entry>
381392 <entry>ISO 8859-8, <acronym>ECMA</> 121</entry>
382393 <entry>Latin/Hebrew</entry>
394+ <entry>1</entry>
383395 <entry></entry>
384396 </row>
385397 <row>
386398 <entry><literal>JOHAB</literal></entry>
387399 <entry><acronym>JOHAB</></entry>
388400 <entry>Korean (Hangul)</entry>
401+ <entry>1-3</entry>
389402 <entry></entry>
390403 </row>
391404 <row>
392405 <entry><literal>KOI8</literal></entry>
393406 <entry><acronym>KOI</acronym>8-R(U)</entry>
394407 <entry>Cyrillic</entry>
395- <entry>KOI8R</entry>
408+ <entry>1</entry>
409+ <entry><literal>KOI8R</></entry>
396410 </row>
397411 <row>
398412 <entry><literal>LATIN1</literal></entry>
399413 <entry>ISO 8859-1, <acronym>ECMA</> 94</entry>
400414 <entry>Western European</entry>
401- <entry>ISO88591</entry>
415+ <entry>1</entry>
416+ <entry><literal>ISO88591</></entry>
402417 </row>
403418 <row>
404419 <entry><literal>LATIN2</literal></entry>
405420 <entry>ISO 8859-2, <acronym>ECMA</> 94</entry>
406421 <entry>Central European</entry>
407- <entry>ISO88592</entry>
422+ <entry>1</entry>
423+ <entry><literal>ISO88592</></entry>
408424 </row>
409425 <row>
410426 <entry><literal>LATIN3</literal></entry>
411427 <entry>ISO 8859-3, <acronym>ECMA</> 94</entry>
412428 <entry>South European</entry>
413- <entry>ISO88593</entry>
429+ <entry>1</entry>
430+ <entry><literal>ISO88593</></entry>
414431 </row>
415432 <row>
416433 <entry><literal>LATIN4</literal></entry>
417434 <entry>ISO 8859-4, <acronym>ECMA</> 94</entry>
418435 <entry>North European</entry>
419- <entry>ISO88594</entry>
436+ <entry>1</entry>
437+ <entry><literal>ISO88594</></entry>
420438 </row>
421439 <row>
422440 <entry><literal>LATIN5</literal></entry>
423441 <entry>ISO 8859-9, <acronym>ECMA</> 128</entry>
424442 <entry>Turkish</entry>
425- <entry>ISO88599</entry>
443+ <entry>1</entry>
444+ <entry><literal>ISO88599</></entry>
426445 </row>
427446 <row>
428447 <entry><literal>LATIN6</literal></entry>
429448 <entry>ISO 8859-10, <acronym>ECMA</> 144</entry>
430449 <entry>Nordic</entry>
431- <entry>ISO885910</entry>
450+ <entry>1</entry>
451+ <entry><literal>ISO885910</></entry>
432452 </row>
433453 <row>
434454 <entry><literal>LATIN7</literal></entry>
435455 <entry>ISO 8859-13</entry>
436456 <entry>Baltic</entry>
437- <entry>ISO885913</entry>
457+ <entry>1</entry>
458+ <entry><literal>ISO885913</></entry>
438459 </row>
439460 <row>
440461 <entry><literal>LATIN8</literal></entry>
441462 <entry>ISO 8859-14</entry>
442463 <entry>Celtic</entry>
443- <entry>ISO885914</entry>
464+ <entry>1</entry>
465+ <entry><literal>ISO885914</></entry>
444466 </row>
445467 <row>
446468 <entry><literal>LATIN9</literal></entry>
447469 <entry>ISO 8859-15</entry>
448470 <entry>LATIN1 with Euro and accents</entry>
471+ <entry>1</entry>
449472 <entry>ISO885915</entry>
450473 </row>
451474 <row>
452475 <entry><literal>LATIN10</literal></entry>
453476 <entry>ISO 8859-16, <acronym>ASRO</> SR 14111</entry>
454477 <entry>Romanian</entry>
455- <entry>ISO885916</entry>
478+ <entry>1</entry>
479+ <entry><literal>ISO885916</></entry>
456480 </row>
457481 <row>
458482 <entry><literal>MULE_INTERNAL</literal></entry>
459483 <entry>Mule internal code</entry>
460484 <entry>Multi-lingual Emacs</entry>
485+ <entry>1-4</entry>
461486 <entry></entry>
462487 </row>
463488 <row>
464489 <entry><literal>SJIS</literal></entry>
465490 <entry>Shift JIS</entry>
466491 <entry>Japanese</entry>
467- <entry>Mskanji, ShiftJIS, WIN932, Windows932</entry>
492+ <entry>1-2</entry>
493+ <entry><literal>Mskanji</>, <literal>ShiftJIS</>, <literal>WIN932</>, <literal>Windows932</></entry>
468494 </row>
469495 <row>
470496 <entry><literal>SQL_ASCII</literal></entry>
471497 <entry><acronym>ASCII</acronym></entry>
472498 <entry>English</entry>
499+ <entry>1</entry>
473500 <entry></entry>
474501 </row>
475502 <row>
476503 <entry><literal>UHC</literal></entry>
477504 <entry>Unified Hangul Code</entry>
478505 <entry>Korean</entry>
479- <entry>WIN949, Windows949</entry>
506+ <entry>1-2</entry>
507+ <entry><literal>WIN949</>, <literal>Windows949</></entry>
480508 </row>
481509 <row>
482510 <entry><literal>UTF8</literal></entry>
483511 <entry>Unicode, 8-bit</entry>
484512 <entry><emphasis>all</></entry>
485- <entry>Unicode</entry>
513+ <entry>1-3</entry>
514+ <entry><literal>Unicode</></entry>
486515 </row>
487516 <row>
488517 <entry><literal>WIN866</literal></entry>
489518 <entry>Windows CP866</entry>
490519 <entry>Cyrillic</entry>
491- <entry>ALT</entry>
520+ <entry>1</entry>
521+ <entry><literal>ALT</></entry>
492522 </row>
493523 <row>
494524 <entry><literal>WIN874</literal></entry>
495525 <entry>Windows CP874</entry>
496526 <entry>Thai</entry>
527+ <entry>1</entry>
497528 <entry></entry>
498529 </row>
499530 <row>
500531 <entry><literal>WIN1250</literal></entry>
501532 <entry>Windows CP1250</entry>
502533 <entry>Central European</entry>
534+ <entry>1</entry>
503535 <entry></entry>
504536 </row>
505537 <row>
506538 <entry><literal>WIN1251</literal></entry>
507539 <entry>Windows CP1251</entry>
508540 <entry>Cyrillic</entry>
509- <entry>WIN</entry>
541+ <entry>1</entry>
542+ <entry><literal>WIN</></entry>
510543 </row>
511544 <row>
512545 <entry><literal>WIN1256</literal></entry>
513546 <entry>Windows CP1256</entry>
514547 <entry>Arabic</entry>
548+ <entry>1</entry>
515549 <entry></entry>
516550 </row>
517551 <row>
518552 <entry><literal>WIN1258</literal></entry>
519553 <entry>Windows CP1258</entry>
520554 <entry>Vietnamese</entry>
521- <entry>ABC, TCVN, TCVN5712, VSCII</entry>
555+ <entry>1</entry>
556+ <entry><literal>ABC</>, <literal>TCVN</>, <literal>TCVN5712</>, <literal>VSCII</></entry>
522557 </row>
523558 </tbody>
524559 </tgroup>
@@ -809,9 +844,6 @@ $ <userinput>psql -l</userinput>
809844 <literal>ISO_8859_5</literal>,
810845 <literal>KOI8</literal>,
811846 <literal>LATIN1</literal> to <literal>LATIN4</literal>,
812- <literal>LATIN2</literal>,
813- <literal>LATIN3</literal>,
814- <literal>LATIN4</literal>,
815847 <literal>SJIS</literal>,
816848 <literal>WIN866</literal>,
817849 <literal>WIN1250</literal>,
@@ -841,29 +873,7 @@ $ <userinput>psql -l</userinput>
841873 </row>
842874 <row>
843875 <entry><literal>UTF8</literal></entry>
844- <entry><emphasis>UTF8</emphasis>,
845- <literal>BIG5</literal>,
846- <literal>EUC_CN</literal>,
847- <literal>EUC_JP</literal>,
848- <literal>EUC_KR</literal>,
849- <literal>EUC_TW</literal>,
850- <literal>ISO_8859_5</literal>,
851- <literal>ISO_8859_6</literal>,
852- <literal>ISO_8859_7</literal>,
853- <literal>ISO_8859_8</literal>,
854- <literal>GB18030</literal>,
855- <literal>GBK</literal>,
856- <literal>JOHAB</literal>,
857- <literal>KOI8</literal>,
858- <literal>LATIN1</literal> to <literal>LATIN10</literal>,
859- <literal>SJIS</literal>,
860- <literal>UHC</literal>,
861- <literal>WIN866</literal>,
862- <literal>WIN874</literal>,
863- <literal>WIN1250</literal>,
864- <literal>WIN1251</literal>,
865- <literal>WIN1256</literal>,
866- <literal>WIN1258</literal>
876+ <entry><emphasis>all supported encodings</emphasis>
867877 </entry>
868878 </row>
869879 <row>