Message-ID: <3F686F33.7000003@devo.se>
Date: Wed, 17 Sep 2003 16:26:59 +0200
From: =?ISO-8859-1?Q?Kristian_J=F6rg?= <krjg@devo.se>
Organization: Devo IT AB
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Richard Huxton <dev@archonet.com>, pgsql-sql@postgresql.org
Subject: Re: Sort order with spaces?
References: <3F682DB3.6080905@devo.se> <200309171144.02871.dev@archonet.com>
	<3F6853E4.3000604@devo.se> <1935.1063807618@sss.pgh.pa.us>
In-Reply-To: <1935.1063807618@sss.pgh.pa.us>
Content-Type: multipart/alternative;
	boundary="------------000503090108000705020408"

This is a multi-part message in MIME format.
--------------000503090108000705020408
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit


Tom Lane wrote:

>=?ISO-8859-1?Q?Kristian_J=F6rg?= <krjg@devo.se> writes:
>  
>
>>Unfortunately this does not seem to help! I dumped the database, 
>>recreated the cluster with initdb with LC_COLLATE = C (and even tried 
>>setting LC_CTYPE to C also), and restored the database. The same 
>>ordering appears...
>>    
>>
>
>You didn't do it right then ...
>
>7.2's initdb is not helpful about telling you exactly what locale
>settings it's using, but you could use the contrib/pg_controldata
>utility to check what LC_COLLATE and LC_CTYPE settings got used.
>(If you don't want to build pg_controldata, "strings
>$PGDATA/global/pg_control" will do as a rough-and-ready substitute.)
>  
>
Unfortunately I am using a binary distribution from a RPM package, so I 
don't have the source. Tried the strings stuff though and that worked. I 
have sv_SE as locale for sure. So you are corect. I did not do initdb 
correctly. Shame on me... :-)

>Theoretically it should work to do
>	export LC_COLLATE=C
>	export LC_CTYPE=C
>	initdb
>but if you have LANG or other LC_xxx values in your environment,
>it's possible that there is some conflict.
>
>			regards, tom lane
>
It is possible my locale settings did not get through to initdb since I 
tried using the startup postgres command in /etc/init.d (with som 
modifications of course). I will try again manually this time!

Regards Kristian

>.
>
>  
>

-- 
           \\|//
           (@ @)
+------ooO--(_)--Ooo----------+------------------------------+
| Kristian Jörg               | Phone: +46 54 153395         |
| Devo IT AB                  | Fax:   +46 54 153389         |
| Box 533, SE-651 12 KARLSTAD | mailto:kristian.jorg@devo.se |
| Sweden                      | http://www.devo.se           |
+-----------------------------+------------------------------+


--------------000503090108000705020408
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<br>
<br>
Tom Lane wrote:<br>
<blockquote type="cite" cite="mid1935.1063807618@sss.pgh.pa.us">
  <pre wrap="">=?ISO-8859-1?Q?Kristian_J=F6rg?= <a class="moz-txt-link-rfc2396E" href="mailto:krjg@devo.se">&lt;krjg@devo.se&gt;</a> writes:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Unfortunately this does not seem to help! I dumped the database, 
recreated the cluster with initdb with LC_COLLATE = C (and even tried 
setting LC_CTYPE to C also), and restored the database. The same 
ordering appears...
    </pre>
  </blockquote>
  <pre wrap=""><!---->
You didn't do it right then ...

7.2's initdb is not helpful about telling you exactly what locale
settings it's using, but you could use the contrib/pg_controldata
utility to check what LC_COLLATE and LC_CTYPE settings got used.
(If you don't want to build pg_controldata, "strings
$PGDATA/global/pg_control" will do as a rough-and-ready substitute.)
  </pre>
</blockquote>
Unfortunately I am using a binary distribution from a RPM package, so I
don't have the source. Tried the strings stuff though and that worked.
I have sv_SE as locale for sure. So you are corect. I did not do initdb
correctly. Shame on me... :-)<br>
<blockquote type="cite" cite="mid1935.1063807618@sss.pgh.pa.us">
  <pre wrap="">
Theoretically it should work to do
	export LC_COLLATE=C
	export LC_CTYPE=C
	initdb
but if you have LANG or other LC_xxx values in your environment,
it's possible that there is some conflict.

			regards, tom lane</pre>
</blockquote>
It is possible my locale settings did not get through to initdb since I
tried using the startup postgres command in /etc/init.d (with som
modifications of course). I will try again manually this time!<br>
<br>
Regards Kristian<br>
<blockquote type="cite" cite="mid1935.1063807618@sss.pgh.pa.us">
  <pre wrap="">
.

  </pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">-- 
           \\|//
           (@ @)
+------ooO--(_)--Ooo----------+------------------------------+
| Kristian J&ouml;rg               | Phone: +46 54 153395         |
| Devo IT AB                  | Fax:   +46 54 153389         |
| Box 533, SE-651 12 KARLSTAD | <a class="moz-txt-link-freetext" href="mailto:kristian.jorg@devo.se">mailto:kristian.jorg@devo.se</a> |
| Sweden                      | <a class="moz-txt-link-freetext" href="http://www.devo.se">http://www.devo.se</a>           |
+-----------------------------+------------------------------+</pre>
</body>
</html>

--------------000503090108000705020408--