Skip site navigation (1) Skip section navigation (2)

Re: OS Locale UTF-8

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: OS Locale UTF-8
Date: 2005-04-11 23:47:13
Message-ID: 425B0C81.7020504@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-patches
This would explain the similar failure that I reported and didn't get 
around to digging into. Excellent.

andrew

Simon Riggs wrote:

>I have access to a system with locale of UTF-8. cvstip would no longer
>initdb on this system, as a result of recent renaming of UTF-8 to UTF8.
>
>i.e.
>[userid(at)systemname ~]$ locale
>LANG=en_US.UTF-8
>LC_CTYPE="en_US.UTF-8"
>LC_NUMERIC="en_US.UTF-8"
>LC_TIME="en_US.UTF-8"
>LC_COLLATE="en_US.UTF-8"
>LC_MONETARY="en_US.UTF-8"
>LC_MESSAGES="en_US.UTF-8"
>LC_PAPER="en_US.UTF-8"
>LC_NAME="en_US.UTF-8"
>LC_ADDRESS="en_US.UTF-8"
>LC_TELEPHONE="en_US.UTF-8"
>LC_MEASUREMENT="en_US.UTF-8"
>LC_IDENTIFICATION="en_US.UTF-8"
>LC_ALL=
>
>OS is Fedore Core 3.
>
>Attached patch adds UTF-8 as a synonym for UTF8, so initdb works again
>without needing to specify an encoding, just like it used to.
>
>Whatever we call UTF*8, there will always be somebody who says
>different. 
>
>Best regards, Simon Riggs
>  
>
>------------------------------------------------------------------------
>
>Index: initdb.c
>===================================================================
>RCS file: /projects/cvsroot/pgsql/src/bin/initdb/initdb.c,v
>retrieving revision 1.79
>diff -d -c -r1.79 initdb.c
>*** initdb.c	14 Mar 2005 18:31:23 -0000	1.79
>--- initdb.c	11 Apr 2005 23:12:25 -0000
>***************
>*** 721,726 ****
>--- 721,727 ----
>  	{PG_JOHAB, "???"},
>  #endif
>  
>+ 	{PG_UTF8, "UTF-8"},
>  	{PG_UTF8, "UTF8"},
>  	{PG_UTF8, "utf8"},
>  
>  
>
>------------------------------------------------------------------------
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>      message can get through to the mailing list cleanly
>  
>

In response to

pgsql-patches by date

Next:From: Greg Sabino MullaneDate: 2005-04-12 03:00:13
Subject: Remove unneeded left joins from psql
Previous:From: Simon RiggsDate: 2005-04-11 23:24:05
Subject: OS Locale UTF-8

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group