Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9F4FB6325C0 for ; Sat, 27 Feb 2010 22:21:25 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 80309-04 for ; Sun, 28 Feb 2010 02:21:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 084C26322DD for ; Sat, 27 Feb 2010 22:21:14 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id o1S2LF719498 for pgsql-docs@postgresql.org; Sat, 27 Feb 2010 21:21:15 -0500 (EST) From: Bruce Momjian Message-Id: <201002280221.o1S2LF719498@momjian.us> Subject: Locale example To: PostgreSQL-documentation Date: Sat, 27 Feb 2010 21:21:15 -0500 (EST) X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="ELM1267323675-2190-0_" Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.185 tagged_above=-10 required=5 tests=BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 201002/49 X-Sequence-Number: 5365 --ELM1267323675-2190-0_ Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" I have updated the locale example in the manual to be more explicit with the attached patch. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do --ELM1267323675-2190-0_ Content-Transfer-Encoding: 7bit Content-Type: text/x-diff Content-Disposition: inline; filename="/rtmp/diff" Index: charset.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/charset.sgml,v retrieving revision 2.96 diff -c -r2.96 charset.sgml *** charset.sgml 3 Feb 2010 17:25:05 -0000 2.96 --- charset.sgml 28 Feb 2010 02:15:36 -0000 *************** *** 68,75 **** in Sweden (SE). Other possibilities might be en_US (U.S. English) and fr_CA (French Canadian). If more than one character set can be used for a ! locale then the specifications look like this: ! cs_CZ.ISO8859-2. What locales are available on your system under what names depends on what was provided by the operating system vendor and what was installed. On most Unix systems, the command locale -a will provide a list of available locales. --- 68,82 ---- in Sweden (SE). Other possibilities might be en_US (U.S. English) and fr_CA (French Canadian). If more than one character set can be used for a ! locale then the specifications can take the form ! language_territory.codeset. For example, ! fr_BE.UTF-8 represents the French language (fr) as ! spoken in Belgium (BE), with a UTF-8 character set ! encoding. ! ! ! ! What locales are available on your system under what names depends on what was provided by the operating system vendor and what was installed. On most Unix systems, the command locale -a will provide a list of available locales. --ELM1267323675-2190-0_--